Dynamic table

[PBRM]

Hi all,

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

	type A	type B	type C	type D
name A	-	2	-	-
name B	-	4	1	-
name C	-	-	-	-

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

	type B	type C
name A	2	-
name B	4	1

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

thanks in advance!

[Taoufiq_Zarra · Accepted solution]

hi,

@PBRM  check suppress when Value is Null in UserDimension

[PBRM]

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