Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

nboccassini
Contributor

Hide row in pivot table

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?

4 Replies
Not applicable

Re: Hide row in pivot table

Hi Gabriele,

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

Suppress null.PNG.png

nboccassini
Contributor

Re: Hide row in pivot table

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.

MVP
MVP

Re: Hide row in pivot table

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

Community Browser