Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI all,
I've a pivot table with 6 dimensions and some expression like this:
EXPRESS 1 EXPRESS 2 ........
TOTAL
ITALY 1000 20000
A 700 .....
B 300 .....
300 ......
300 ...............
C
D
E
F
FRANCE
.........
Is there a way to hide the sublevel with empty value of dimension?
Hi Gabriele,
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:
Expression1 (Column1):
=if(IsNull(Column(1), Null(), <The-Expression1>)
Expression2 (Column2):
=if(IsNull(Column(2), Null(), <The-Expression2>)
etc.
Or with Set Analysis. But therefor we would need more details to help..
- Ralf
See here a similar case: How to hide some rows based of criteria resulting from a complex expression ?
- Marcus