cyclic group sort

bellesol — Sun, 14 Feb 2021 12:59:23 GMT

Hi,

I have one cyclic group in my model and I use it in a table and in a graph,

so when a user selects for example - "year", he see data by "year" in the graph and in the table,

The problem is the sort,

I used the sort in the group edit,

Is it possible to change the sort of the cyclic dimension based on the chart? so that the sort in the table will be descending while the graph will be ascending?

I have 5 dimension in the cyclic group, and in some of them I use expression for sorting.

Thanks !

Re: cyclic group sort

MayilVahanan — Mon, 15 Feb 2021 02:14:56 GMT

HI @bellesol

May be try like below

=If(GetCurrentField(NewGroup)='Year', Year, Month)

Here "NewGroup" is the cyclic group name

topic Re: cyclic group sort in QlikView

cyclic group sort

Re: cyclic group sort