Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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
Valued Contributor II

Re: Hiding rows in pivot if one value is zero

This is one way to do.Check the file

7 Replies
sujeetsingh
Honored Contributor III

Re: Hiding rows in pivot if one value is zero

One thing you can try is supress null...

but i want to know that which are dimensions??

means ...

Not applicable

Re: Hiding rows in pivot if one value is zero

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
Honored Contributor III

Re: Hiding rows in pivot if one value is zero

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
Valued Contributor II

Re: Hiding rows in pivot if one value is zero

This is one way to do.Check the file

Not applicable

Re: Hiding rows in pivot if one value is zero

Thanks Sivaraj,

It worked and is awesome.

Not applicable

Re: Hiding rows in pivot if one value is zero

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

Re: Hiding rows in pivot if one value is zero

Hi Shreeaaradhya,

You can hide column.

Chart properties->presentation->Hide Column

--Prabhu Ch

Community Browser