Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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
Highlighted
Partner
Partner

Re: To show null values in pivot table

Hi All,

Have any idea on the above scenario?

Thanks,

Vidhya