topic Re: Hiding rows in pivot if one value is zero in QlikView

Hiding rows in pivot if one value is zero

Fri, 18 Jan 2013 03:09:17 GMT

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.

Regards

Nassar

sujeetsingh — Fri, 18 Jan 2013 04:08:00 GMT

One thing you can try is supress null...

but i want to know that which are dimensions??

means ...

Fri, 18 Jan 2013 04:26:06 GMT

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.

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.

sujeetsingh — Fri, 18 Jan 2013 04:31:56 GMT

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 — Fri, 18 Jan 2013 05:13:07 GMT

This is one way to do.Check the file

Fri, 18 Jan 2013 05:48:17 GMT

Thanks Sivaraj,

It worked and is awesome.

Fri, 18 Jan 2013 07:06:03 GMT

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

Fri, 18 Jan 2013 07:57:56 GMT

Hi Shreeaaradhya,

You can hide column.

Chart properties->presentation->Hide Column

--Prabhu Ch