Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
vidhya91gct
Partner - Contributor
Partner - Contributor

To show null values in pivot table

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)

Test.PNG

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

1 Reply
vidhya91gct
Partner - Contributor
Partner - Contributor
Author

Hi All,

Have any idea on the above scenario?

Thanks,

Vidhya