Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Error in Sorting in Qlik Sense

Hi Everyone ,

I am Gaurav,

facing the issue of sorting in qliksense for one of my Bar Chart.

please find the Attached image for the sample.

i already applied the sorting  as numerically ( ascending ) in the option in right panel.

In the image , it can be seen in the X axis after 1 - 2 - 25 is coming then 4 - 3 .

please assist.

error in sorting.png

1 Solution

Accepted Solutions
Patrik_Lundblad
Employee
Employee

Hi Gaurav,

If you check the sorting panel you see a number next to the panes. In this case #1 is Sum of Installment. If you want to sort by x-axis instead you drag the pane installments so that it's above the sum of installments. Then the sorting will be done on x-axis before y-axis.

Best regards,

Patrik

View solution in original post

6 Replies
sunilkumarqv
Specialist II
Specialist II

HI gaurav,

On sorting

Use sort by expression as your dimension field

Anonymous
Not applicable
Author

Hi Sunil,

Thanks for a quick replay.

Please find the attached screen shot for the same.

error in sorting_1.png

Can you please help out for the expression.

sunilkumarqv
Specialist II
Specialist II

what is your x-axis

if installation then

in expression as =installation

Anonymous
Not applicable
Author

Hi Sunil,

already done with  that expression but not getting the right values.

my x axis is still not in sorting format.

Please see the attached screen shot.

error in sorting_2.png

Patrik_Lundblad
Employee
Employee

Hi Gaurav,

If you check the sorting panel you see a number next to the panes. In this case #1 is Sum of Installment. If you want to sort by x-axis instead you drag the pane installments so that it's above the sum of installments. Then the sorting will be done on x-axis before y-axis.

Best regards,

Patrik

Anonymous
Not applicable
Author

Hi Patrik,

Great !!!

finally it works

Cheers