Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

zagzebski
Contributor

Automate sorting

I have a chart with an expression for each month. My sort order is January, then February, then March, etc. When I select a month (say October) I have a condition that hides any month that is not equal to the selection. However the sort order is still based on January.

Is there a way, in my example above, to keep the sort order by month, but when I select on October it sorts on October, then when I deselect October it goes back to sorting by Jan, then Feb, then March, etc.?

Thanks in advance for any help.

3 Replies
Not applicable

Re: Automate sorting

What are your current settings in Chart Properties > Sort?

zagzebski
Contributor

Re: Automate sorting

Jan - numeric value descending, then Feb - numeric value descending, then Mar - numeric value descending, etc.

Also allow interactive sort is checked.

Not applicable

Re: Automate sorting

You can use variables in the Sort expression.  Do you have a sample file?

Community Browser