topic Re: Hyde a row in a pivot table in QlikView

Hyde a row in a pivot table

Roberto_Licciardello — Thu, 29 Oct 2020 12:25:01 GMT

Hello,
I have a problem that I cannot solve.
in a pivot table I want not to see a row if one of the measures is equal to 0.

for example the lines marked in red in the figure must not be seen.

thank you so much

Fernando_Fabregas — Thu, 29 Oct 2020 14:44:28 GMT

Hi Roberto. You can try this:

1) In all measures of pivot table (except "YourFieldToCheckZero"), add the following condition:

if( Sum( YourFieldToCheckZero ) = 0, 0, Sum(YourMeasureY) )

or....

if( Column(x) = 0, 0, Sum(MeasureY) )

Replace the "x" with number of column to check. This works only if user don't swap columns.

2) Uncheck "Include zero values" in Data Managment panel

It should work fine...

Regards, Fernando

PD: che bella machina la Alfa Giulia !!

Roberto_Licciardello — Tue, 10 Nov 2020 10:52:48 GMT

Hi, thanks for the reply. I try with solution 1) modifying it a bit.

I have already put 2 in place, but I have more than one column in the pivot table