To show null values in pivot table

[vidhya91gct]

Hi All,

I am new in qlikview ,I want to show the pivot table as in below format(to show all the values include no LRR planned and LRR Actual)

LRR_Planned  

TBD

RR

TES

NA

----------------

LRR_Actual

TBD

RR

TES

NA

LRR _Projects:

23747

19744

17333

20733

LRR_Plants:

India

USA,

UK,

-----------------------

I have tried and getting filtered null values(if there is no LRR Actual or LRR Planned , it is filterred).Please help me on it.

Thanks & Regards,

Vidhya

[vidhya91gct]

Hi All,

Have any idea on the above scenario?

Thanks,

Vidhya