
Contributor
2018-09-12
09:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
992 Views
2 Replies


Partner - Specialist III
2018-09-13
07:22 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
929 Views

Creator II
2018-09-27
05:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi mohit.rawal
You can use Data handling on Chart Edit and then uncheck Include zero values
Hope this helps,
Justin.
929 Views
