Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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