Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
binhogarcia
Contributor
Contributor

How to sort a dimension in a bar chart

People,

Good afternoon!

I would like to sort a dimension (hour) in a bar chart, but it's not working. Could you help me, please?

Bar Chart.jpg

5 Replies
OmarBenSalem
Partner
Partner

put your hour dimension in the sorting tab above all the other fields

shraddha_g
Partner
Partner

in Sorting Option

1st should be your Dimension (Hour)

Screenshot shows that you have sorted according to your measure.

In Sorting, Put Measure at 2nd Position

binhogarcia
Contributor
Contributor

It worked!!!


I'm totally newbie! 😃


Thanks, omar!

mark6505
Partner
Partner

Hi

If the above aren't working correctly, it could be it is treating the values as a string.

Make sure it is at the top in your sorting.

Turn off auto sorting.

Choose sort by Expressions.

Add NUM(Hour) or what ever the dimension is called.

Mark

ankitaag
Partner
Partner

Hi,

In the sorting tab, move the hour dimension to the first and select "sort numerically" - ascending.

"Sort numerically" will work if he hour dimension is numeric. If it is string then you need to convert it into num using num#.

Thanks!