Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Partner
Partner

Remove null values row on pivot table

Hi All,

Please help me on the below,

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

Test.PNG

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

3 Replies
Highlighted
Or
Valued Contributor II

Re: Remove null values row on pivot table

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?

Highlighted
Partner
Partner

Re: Remove null values row on pivot table

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

Highlighted
Or
Valued Contributor II

Re: Remove null values row on pivot table

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