topic Re: Hide row in pivot table in QlikView

Hide row in pivot table

nboccassini — Thu, 28 Nov 2013 12:54:20 GMT

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 ...............

FRANCE

.........

Is there a way to hide the sublevel with empty value of dimension?

Re: Hide row in pivot table

Thu, 28 Nov 2013 12:58:13 GMT

Hi Gabriele,

Use Suppress null Value option for the dimension.Refer to the image.

Re: Hide row in pivot table

nboccassini — Thu, 28 Nov 2013 13:04:24 GMT

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.

Re: Hide row in pivot table

rbecher — Mon, 02 Dec 2013 21:32:41 GMT

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

Re: Hide row in pivot table

marcus_sommer — Tue, 03 Dec 2013 05:55:47 GMT

- Marcus