Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting Values Charts and Tables

Hi, not sure why I can't get these values to sort in order!

I was trying to create a chart with the top three vales of each category but could not get it to work so I then tried to do the same thing in a pivot table and the same issue is happeneing.

Here is the table. You can see that the results start off sorting but then half way down the list it mixes up the values

I have tried using a sort expression

=FieldValueCount('Response_Level_2') +rank(sum(Ans_Minutes))

But not getting anywhere - can you help.

Thanks

Rob

6 Replies
Not applicable
Author

Apologies, here is the table

Barriers sort table.png

Not applicable
Author

post sample qvw file...

Not applicable
Author

qvw file now attached

Thanks

Rob

Not applicable
Author

Check attached file

BTW try to eliminate syn key (it may cause some unexpected effects)

table.PNG

Not applicable
Author

Hi Pari, I must be honest I'm not sure what you have done - and is there an answer for the chart?

Thanks

Rob

Not applicable
Author

if you open my file

is sort order correct?