Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Specialist
Specialist

Sort

How to set the bars chart in ascending posintion , witouth using sort order

1 Solution

Accepted Solutions
rubenmarin

Hi John, you can also try the 'Y Value' ascending option in the sort tab, it uses the value of the first expression to sort the dimension.

View solution in original post

12 Replies
adamdavi3s
Master
Master

Why can't you use a sort order?

shraddha_g
Partner - Master III
Partner - Master III

Sort it in Load script using Order by and then use load order in chart unchecking any sorting option.

I hope it is helpful.

adamdavi3s
Master
Master

Ok so what are you expecting it to sort by?

If you're expecting it to sort as you have loaded, then you need to choose the load-order option on the sort tab

Please remember to mark this as helpful or the correct answer if I have helped you or answered your question.

smilingjohn
Specialist
Specialist
Author

Hi Adam

Actaully i  2 expressions and one dimensions .. so now i want to show the bar chart by ascending order ,

I hope i am clear , to achive this i can go for load order in this script

If iam trying to do it on the sort , its not  makeing any effect

adamdavi3s
Master
Master

Hi John,

Copy your expression into the sort tab expression part and sort the dimension by that?

rubenmarin

Hi John, you can also try the 'Y Value' ascending option in the sort tab, it uses the value of the first expression to sort the dimension.

Not applicable

perhaps, you need to give a sample to show what is your real problem

rupamjyotidas
Specialist
Specialist

WHy you don't want to use Sort ORder. I can see you want to see by Ascending values. Or do you want by dimensions, Apart from what has been advised, you can also look at DUAL() function to defined your Dimension. Its lot helpful

Anil_Babu_Samineni

What is your achievement, can you please share the screen shot which demonstrates the output

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful