Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
gauravgs
Contributor

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
Employee
Employee

Re: Error in Sorting in Qlik Sense

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

6 Replies
sunilkumarqv
Valued Contributor II

Re: Error in Sorting in Qlik Sense

HI gaurav,

On sorting

Use sort by expression as your dimension field

gauravgs
Contributor

Re: Error in Sorting in Qlik Sense

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
Valued Contributor II

Re: Error in Sorting in Qlik Sense

what is your x-axis

if installation then

in expression as =installation

gauravgs
Contributor

Re: Error in Sorting in Qlik Sense

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

Employee
Employee

Re: Error in Sorting in Qlik Sense

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

gauravgs
Contributor

Re: Error in Sorting in Qlik Sense

Hi Patrik,

Great !!!

finally it works

Cheers