Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
HI gaurav,
On sorting
Use sort by expression as your dimension field
Hi Sunil,
Thanks for a quick replay.
Please find the attached screen shot for the same.
Can you please help out for the expression.
what is your x-axis
if installation then
in expression as =installation
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.
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
Hi Patrik,
Great !!!
finally it works
Cheers