topic Re: Pivot table automatically suppressing zero/null values in QlikView

Pivot table automatically suppressing zero/null values

vipingarg23 — Tue, 22 Aug 2017 03:56:37 GMT

Hi Team,

I have below pivot table

Dimension1	Dimension2	Expression1 (Total)	Expression2
Country	IND	100000	129
	AUS	0	0

In this pivot table if both expression value is 0/NULL then it is not showing the whole row as below while I am not suppressing any zero/null values.

Dimension1	Dimension2	Expression1(Total)	Expression2
Country	IND	100000	129

Why is automatically suppressing the value. Is there any way to get the first one pivot table. as I don't want to suppress.

Anil_Babu_Samineni — Tue, 22 Aug 2017 03:59:59 GMT

Suppress When value is null ticked option is available in Presentation tab.

Check in expression?

vipingarg23 — Tue, 22 Aug 2017 04:15:01 GMT

I don't want to suppress any value. I am saying that pivot table is

automatically suppressing value if both expressions have zero/null values

as shown above. I don't want to suppress that.

On Tue, Aug 22, 2017 at 9:30 AM, Anil Babu Samineni <

Anil_Babu_Samineni — Tue, 22 Aug 2017 04:16:46 GMT

That's what i am presenting here. Please check those options. i think those options are not checked. May be share image from presentation tab

vipingarg23 — Tue, 22 Aug 2017 04:30:37 GMT

I have checked both checkbox suppress zero/null values. Both are unchecked.

On Tue, Aug 22, 2017 at 9:46 AM, Anil Babu Samineni <

tresB — Tue, 22 Aug 2017 04:52:33 GMT

Could you post your sample qvw that shows the issue?

Anil_Babu_Samineni — Tue, 22 Aug 2017 05:19:35 GMT

Yes, I agree with Tresesco.

But, For validation can you try with Dimensions "Show all values"

vipingarg23 — Tue, 22 Aug 2017 05:56:25 GMT

Thanks guys for your help. I found my mistake. There were if condition

applied in my expression. Now it is working fine.

On Tue, Aug 22, 2017 at 10:49 AM, Anil Babu Samineni <