Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Bar Chart sorting

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

1 Solution

Accepted Solutions
Not applicable

Re: Bar Chart sorting

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

6 Replies
konstantin
Contributor III

Re: Bar Chart sorting

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

sushil353
Honored Contributor II

Re: Bar Chart sorting

Hi,

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

HTH

Sushil

Re: Bar Chart sorting

Hi,

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

Regards

ASHFAQ

Not applicable

Re: Bar Chart sorting

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

Hi,

Can you attache sample to check with.

regards

ASHFAQ

Not applicable

Re: Bar Chart sorting

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

Community Browser