Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to Sort

Hi,

I created a straight table then when I tried to sort it in the chart properties it is not sorting, only the first two lines are sorting. I used the expressions below:

=Num(Count({1<Status={'Completed'}>} Status),'##0')

=Num(Count({1<Status={'Assigned'}>} Status),'##0')

=Num(Count({1<Status={'Work in Progress'}>} Status),'##0')

I'm trying to sort the table referencing the completed column, when I try to sort it only Training and User Access moves.

Chart.png

What should I do?

Thanks in advance.

2 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Please post a sample qvw document that illustrates the problem.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Mark_Little
Luminary
Luminary

HI,

As Jonathan suggested a sample QVW would be helpful,

One thing to try, in the Sort tab on the chart properties highlight the category column and then tick the Expression box and add the expression

=Num(Count({1<Status={'Completed'}>} Status),'##0')


Un-tick any other options.


Mark