Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding rows in pivot if one value is zero

Dear All,

I have attached the excel raw data and qvw file.

I have put a pivot table in QV, however i need to hide the complete row if one of the value in the pivot is 0.

Is it possible using expression in pivot table.?

The final result should look like th below. Here it is hiding 3 rows where some value are 0 and displaying only two rows.

H2ABCDEGrand Total
ABC-100-150-50-45-75-420
CDE-300-55-30-55-400-840

Regards

Nassar

1 Solution

Accepted Solutions
sivarajs
Specialist II
Specialist II

This is one way to do.Check the file

View solution in original post

7 Replies
sujeetsingh
Master III
Master III

One thing you can try is supress null...

but i want to know that which are dimensions??

means ...

Not applicable
Author

Thanks for your reply,

I tried suppressing null but it only hides where all the values are null or zero. Here you have the raw data.

H1H2H3
AXYZ-200
AABC-100
ACDE-300
BABC-150
CIJK-60
DABC-45
DCDE-55
EOPQ
EABC-75
CCDE-30
CABC-50
BCDE-55
BIJK-105
ECDE-400

and the pivot looks like this in excel. i want to display only first two rows as i have values for all.,i.e for A,B,C,D,E.

Sum of H3H1
H2ABCDEGrand Total
ABC-100-150-50-45-75-420
CDE-300-55-30-55-400-840
IJK-105-60-165
OPQ
XYZ-200-200
Grand Total-600-310-140-100-475-1625
sujeetsingh
Master III
Master III

So now we have to use H1 and H2 as dimension and sun(h3) as expression ..

I tried like this but i didnt get any zero value

sivarajs
Specialist II
Specialist II

This is one way to do.Check the file

Not applicable
Author

Thanks Sivaraj,

It worked and is awesome.

Not applicable
Author

hello,

can you please help me for this

I want to hide the expression column in which I am calculating the value but that value I am using in next expression

and my condition is that i want to hide that calculated 1st column and resulted 2nd column should be visible

Not applicable
Author

Hi Shreeaaradhya,

You can hide column.

Chart properties->presentation->Hide Column

--Prabhu Ch