Discussion Board for collaboration related to Creating Analytics for QlikView.
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.
Go to Solution.
This is one way to do.Check the file
One thing you can try is supress null...
but i want to know that which are dimensions??
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.
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
It worked and is awesome.
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
You can hide column.
Chart properties->presentation->Hide Column