How to sort data in Qlik Sense desktop

[mohit_rawal]

So I have an Excel file with a table for unique codes and corresponding values

But whenever I upload the table, it sorts all the zero values first and then the non zero values

Also, the sorting order is messed up.

Any ideas how to fix this. I have attached the screenshots of Excel file and the Qlik Sense data that I want to see.

[felipedl]

Hi Mohit,

Do you need to display the zero values?

There's an option to remove the zero values from the expresion on the graph.

[justinphamvn]

Hi mohit.rawal

You can use Data handling on Chart Edit and then uncheck Include zero values

Hope this helps,

Justin.