Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
vipingarg23
Creator
Creator

Pivot table automatically suppressing zero/null values

Hi Team,

I have below pivot table

Dimension1Dimension2Expression1 (Total)Expression2
CountryIND100000129
AUS00

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.

Dimension1Dimension2Expression1(Total)Expression2
CountryIND100000129

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

1 Solution

Accepted Solutions
Anil_Babu_Samineni

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

7 Replies
Anil_Babu_Samineni

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

OR

Check in expression?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vipingarg23
Creator
Creator
Author

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

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vipingarg23
Creator
Creator
Author

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

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

tresesco
MVP
MVP

Could you post your sample qvw that shows the issue?

Anil_Babu_Samineni

Yes, I agree with Tresesco.

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

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
vipingarg23
Creator
Creator
Author

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 <