conditional sort issue

Mon, 02 Mar 2015 13:28:23 GMT

Hi,

I have a cyclic group with different kind of dimensions in the group. In the sort, I want that if the selected dimension in the cyclic group is Time then sort alphabetically, otherwise sort by Y value

In the sort expression, I have put it something like this

if(GetCurrentField('sale dimensions') <> 'Time',
sum(saleamount)
)

So basically I have checked both the sort options by expression and then also checked the option sort alphabetically. I assumed that if the condition in the expression is not met, it will then sort alphabetically. This way if the selected dimension in the cyclic group is Time, it will sort alphabetically and if it is other dimensions, it will sort by y value

However, it does not seem to work. Any Ideas?

Shah

Re: conditional sort issue

rubenmarin — Mon, 02 Mar 2015 14:10:33 GMT

Hi Syed, in the "group configuration" dialog (Dimensions tab--> Edit Group--> Select group--> edit) you can set the sort for each field in the group (in the "Sort Fields..." button).

In there, select 'Alphabetical' for the Time fields and Sum(saleamount) for the other fields

topic conditional sort issue in QlikView

conditional sort issue

Re: conditional sort issue