topic Histogram stack. in QlikView

Histogram stack.

Thu, 02 Apr 2015 10:46:26 GMT

Hello everyone,

histogram stack.

How do I order the bricks of the graph so that it is below the highest value and then to decrease?

Thank You

Gian Paolo

Thu, 02 Apr 2015 10:51:04 GMT

Hi Gian,

Go to Properties and Sort. Choose Descending. You might need to add the expression and sort on it if you have built the Histogram on the fly

Thu, 02 Apr 2015 14:38:33 GMT

Hello Colin,

I did not understand, please, can you give me some more precise information?

Thank you

G P

Thu, 02 Apr 2015 15:04:59 GMT

Hi Gian,

Basic randomised data for Histogram example attached...

Please see attached example. In Properties -> Sort -> Check Expression Box and add an expression i.e. =COUNT(ID) .

This then sorts by highest histogram category.

Fri, 03 Apr 2015 15:14:56 GMT

Alternatively, Sort by Y-value in this instance

Fri, 03 Apr 2015 15:29:16 GMT

Hi Colin,

I think it will be fine ... thanks!!!!

G P