topic Re: Surpress when null in pivot table in QlikView

Surpress when null in pivot table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi!

I trying to make a pivot table (example below) with two diemnsions.

Dimension2 Dimension1	aa	bb	cc	dd	ee	ff	gg
a	1	-	1	1	1	-	-
b	2	-	2	2	2	-	-
c	3	-	3	3	3	-	-
d	-	-	-	-	-	-	-
f	5	-	5	5	5	-

What I am trying to do is to show all rows from Dimension1 at all times, but to surpress columns when I have null values. Any ideas?

Thank you!

Re: Surpress when null in pivot table

hari8088 — Mon, 25 Sep 2017 07:44:12 GMT

Hi,

In Chart properties dimensions tab select "Suppress when value is null" option for particular dimension.

Re: Surpress when null in pivot table

Anil_Babu_Samineni — Mon, 25 Sep 2017 07:57:32 GMT

What is your measure? You can limit the measure over expression..And need to suppress from presentation tab?

Re: Surpress when null in pivot table

Anonymous — Mon, 25 Sep 2017 08:03:54 GMT

I am losing row "d" when it is checked under Dimension2.

Re: Surpress when null in pivot table

Anonymous — Mon, 25 Sep 2017 08:09:02 GMT

I have multiple exresions. But one of them is a modification of sum( {1} 1) . Otherwiise I am losing rows rows with null values then filters are selected

Re: Surpress when null in pivot table

Anil_Babu_Samineni — Mon, 25 Sep 2017 08:11:14 GMT

Here is the issue? May be attach your application if you feel +ve

Re: Surpress when null in pivot table

Anonymous — Mon, 25 Sep 2017 10:16:50 GMT

Sorry, I can't do that. But I can answer to questoins to help to understand the problem.

Re: Surpress when null in pivot table

Anil_Babu_Samineni — Mon, 25 Sep 2017 10:20:02 GMT

Instead of writing stories, It's easy to make a note over application. Anyway, You can explain to rending the ouput