Discussion Board for collaboration on QlikView Layout & Visualizations.
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?
Go to Solution.
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!
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
You can check option for remove null values in Dimension tab..
Go to chart properties --> Sort --> Select sort by y value.
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)...
Can you attache sample to check with.