topic Remove null values row on pivot table in QlikView

Remove null values row on pivot table

vidhya91gct — Mon, 13 Aug 2018 08:27:14 GMT

Hi All,

Please help me on the below,

I have created pivot table for last 10 days details of the due to display.

I am facing issue on removing null values row and i tried "Suppress when null values" also.

For ex:

I dont have any values in 13737 and 17727 Proj IDs, so i want to remove this proj IDs(Remove 2 rows) and display the other proj IDs.

Thanks in Advance.

Thanks & Regards,

Vidhya K

Re: Remove null values row on pivot table

Or — Mon, 13 Aug 2018 08:51:56 GMT

I'm not sure what you're doing, exactly, but I attempted to re-create this with my own data and the null lines were removed by default (or when Suppress was checked). Are you sure your values are actually null?

Re: Remove null values row on pivot table

vidhya91gct — Mon, 13 Aug 2018 11:16:59 GMT

Hi,

Thanks for the reply,

I have used in the below expression,

if(BaselineMonth=YearMonth and Baseline=TDate and Status_GT='Baseline', maxstring(BaselineGateVal)

if(PlannedMonth=YearMonth and Planned=TDate and Status_GT='Planned', maxstring(PlannedGateVal)

if(ActualMonth=YearMonth and Actual=TDate and Status_GT='Closed',maxstring(ActualGateVal),

if(LRR_PlannedMonth=YearMonth and LRR_Planned=TDate and Status_GT='LRR_Planned',maxstring(LRR_PlannesGateVal),

if(LRR_ActualMonth=YearMonth and LRR_Actual=TDate and Status_GT='LRR_Actual',maxstring(LRR_ActualGateVal),'NA')))))

and Baselinegateval - G1,G2,G3,G4,G5,G6)

Plannedgateval - G1,G2,G3,G4,G5,G6)

Actualgateval - G1,G2,G3,G4,G5,G6)

, i have tried suppress null values in dimension tab also...getting same.

Thanks,

Vidhya K

Re: Remove null values row on pivot table

Or — Mon, 13 Aug 2018 12:06:04 GMT

'NA' is not null. Try replacing it with Null().