Qlikview tips - Sort table by expression columns
Qilkview is designed to use conditional sort (use expressions) on dimension column (DC)level, but not on Expression Column (we use EC for short in the rest part of the article) level. EC we talking about here are the columns that created in the Expression tab. Therefore, it took me some time to figure it out how to use it.
Normally, you can sort the table in the Sort tab by giving an fixed order of all the columns, including dimension columns and expression columns. What if your clients want to select specific data based on the EC and sort the result in another column instead of the default fixed sort priority? Then you will find what we discuss here helpful.
If you have tried to use expression to sort on the EC, you may already found out the Expression option is gray and can not be selected/edited for them in the Sort tab . At the beginning I thought I can not use it. But later I figure it out, you can process this in the Expression option in the DC part. But you can not use Label of the EC which are already defined in the Expression tab, you must use them by repeating all the formula that you used in Expression tab.
Normally, you can sort the table in the Sort tab by giving an fixed order of all the columns, including dimension columns and expression columns. What if your clients want to select specific data based on the EC and sort the result in another column instead of the default fixed sort priority? Then you will find what we discuss here helpful.
If you have tried to use expression to sort on the EC, you may already found out the Expression option is gray and can not be selected/edited for them in the Sort tab . At the beginning I thought I can not use it. But later I figure it out, you can process this in the Expression option in the DC part. But you can not use Label of the EC which are already defined in the Expression tab, you must use them by repeating all the formula that you used in Expression tab.
Comments
Post a Comment