Discussion Board for collaboration on QlikView Layout & Visualizations.
I've a pivot table with 6 dimensions and some expression like this:
EXPRESS 1 EXPRESS 2 ........
ITALY 1000 20000
A 700 .....
B 300 .....
Is there a way to hide the sublevel with empty value of dimension?
Use Suppress null Value option for the dimension.Refer to the image.
The problem is that dimensions 4-5-6 are not always empty and if I "suppress when value in null", qlikview suppress these dimensions for the entire pivot.
Maybe you can combine the expressions in a way that if one expression is NULL all other expressions are also NULL:
=if(IsNull(Column(1), Null(), <The-Expression1>)
=if(IsNull(Column(2), Null(), <The-Expression2>)
Or with Set Analysis. But therefor we would need more details to help..
See here a similar case: How to hide some rows based of criteria resulting from a complex expression ?