topic Re: Dynamic table in QlikView

Dynamic table

PBRM — Tue, 08 Jun 2021 09:52:58 GMT

Hi all,

Any ideas how to solve my problem? I have a pivot table, something like:

To get a clear overview, I would like to skip all blank rows and columns to get something like:

Is there an easy way to get this done within a pivot table?

thanks in advance!

Taoufiq_Zarra — Tue, 08 Jun 2021 11:02:10 GMT

hi,

@PBRM check suppress when Value is Null in UserDimension

PBRM — Tue, 08 Jun 2021 11:25:32 GMT

I'm ashamed that I didn't come up with this myself. 🙈 Qlikview 1.01. Thanks Taoufiq ZARRA!!