topic Re: Bar Chart sorting in QlikView

Bar Chart sorting

Mon, 22 Sep 2014 06:29:45 GMT

Hello everyone,

I have a problem with my bar chart sort order.

It should be sorted by value (max first).

Works fine if no filters are selected.

As soon as I apply a filter, the sorting goes crazy and shows null-values. Null-Values shoulden't be shown too...

My sorting expression looks like sum(Value).

Anyone know this problem?

Best regards,

Moritz

Re: Bar Chart sorting

Anonymous — Mon, 22 Sep 2014 06:35:58 GMT

you need sort to sort by Y-value (descending)

and in the presentation tab, make sure you have checked "Suppress Missing" and "Suppress Zero-Values" to hide null and zero values

Re: Bar Chart sorting

sushil353 — Mon, 22 Sep 2014 06:36:56 GMT

Hi,

You can check option for remove null values in Dimension tab..

HTH

Sushil

Re: Bar Chart sorting

ashfaq_haseeb — Mon, 22 Sep 2014 06:38:43 GMT

Hi,

Go to chart properties --> Sort --> Select sort by y value.

Regards

ASHFAQ

Re: Bar Chart sorting

Mon, 22 Sep 2014 06:43:16 GMT

Thank you guys for your quick answer.

To to NUll-Value problem:

I already did what you suggest. All of these options are checked.

To the sorting-problem:

As I have 2 Dimensions (always only one visible), the sort by Y-value isn't available for the second...

So thats why I tried it with sum(value)...

Any suggestions?

Re: Bar Chart sorting

ashfaq_haseeb — Mon, 22 Sep 2014 06:45:30 GMT

Hi,

Can you attache sample to check with.

regards

ASHFAQ

Re: Bar Chart sorting

Mon, 22 Sep 2014 06:49:23 GMT

Ah, I found the solution to my problem.

In the Dimension Limits I say 'Show only values that are: Greater Than 0 exact amount', the sorting works just fine & there are no NULL-values...

Anyway, thank you for your help !

Best regards & have a nice day!

Moritz