topic Re: How to sort data in Qlik Sense desktop in Connectivity & Data Prep

How to sort data in Qlik Sense desktop

mohit_rawal — Wed, 12 Sep 2018 13:56:00 GMT

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 — Thu, 13 Sep 2018 11:22:13 GMT

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 — Thu, 27 Sep 2018 09:13:40 GMT

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

Hope this helps,

Justin.