topic Re: Unable to Sort in QlikView

Unable to Sort

Anonymous — Tue, 09 Feb 2016 12:01:34 GMT

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.

What should I do?

Thanks in advance.

Re: Unable to Sort

jonathandienst — Tue, 09 Feb 2016 13:50:56 GMT

Please post a sample qvw document that illustrates the problem.

Re: Unable to Sort

Mark_Little — Tue, 09 Feb 2016 14:03:02 GMT

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