Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to sort data in Qlik Sense desktop

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.



2 Replies
Highlighted
Partner
Partner

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.

Highlighted
Creator II
Creator II

Hi mohit.rawal

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

zero.png

Hope this helps,

Justin.