topic To show null values in pivot table in QlikView https://community.qlik.com/t5/QlikView/To-show-null-values-in-pivot-table/m-p/135920#M602404 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am new in qlikview ,I want to show the pivot table as in below format(<SPAN style="font-size: 13.3333px;">to show all the values include no LRR planned and LRR Actual)</SPAN></P><P></P><P><IMG alt="Test.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210755_Test.PNG" style="font-size: 13.3333px;" /></P><P></P><P><STRONG>LRR_Planned</STRONG>&nbsp;&nbsp; </P><P><SPAN style="font-size: 10pt;">TBD</SPAN></P><P><SPAN style="font-size: 10pt;">RR</SPAN></P><P><SPAN style="font-size: 10pt;">TES</SPAN></P><P>NA</P><P>----------------</P><P><SPAN style="font-size: 13.3333px;"><STRONG>LRR_Actual</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">TBD</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">RR</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">TES</SPAN></P><P style="font-size: 13.3333px;">NA</P><P></P><P><STRONG>LRR _Projects:</STRONG></P><P>23747</P><P>19744</P><P>17333</P><P>20733</P><P></P><P><STRONG>LRR_Plants:</STRONG></P><P>India</P><P>USA,</P><P>UK,</P><P>-----------------------</P><P></P><P>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.</P><P></P><P>Thanks &amp; Regards,</P><P>Vidhya </P></BODY></HTML> Tue, 14 Aug 2018 07:37:18 GMT vidhya91gct 2018-08-14T07:37:18Z To show null values in pivot table https://community.qlik.com/t5/QlikView/To-show-null-values-in-pivot-table/m-p/135920#M602404 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am new in qlikview ,I want to show the pivot table as in below format(<SPAN style="font-size: 13.3333px;">to show all the values include no LRR planned and LRR Actual)</SPAN></P><P></P><P><IMG alt="Test.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/210755_Test.PNG" style="font-size: 13.3333px;" /></P><P></P><P><STRONG>LRR_Planned</STRONG>&nbsp;&nbsp; </P><P><SPAN style="font-size: 10pt;">TBD</SPAN></P><P><SPAN style="font-size: 10pt;">RR</SPAN></P><P><SPAN style="font-size: 10pt;">TES</SPAN></P><P>NA</P><P>----------------</P><P><SPAN style="font-size: 13.3333px;"><STRONG>LRR_Actual</STRONG></SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">TBD</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">RR</SPAN></P><P style="font-size: 13.3333px;"><SPAN style="font-size: 10pt;">TES</SPAN></P><P style="font-size: 13.3333px;">NA</P><P></P><P><STRONG>LRR _Projects:</STRONG></P><P>23747</P><P>19744</P><P>17333</P><P>20733</P><P></P><P><STRONG>LRR_Plants:</STRONG></P><P>India</P><P>USA,</P><P>UK,</P><P>-----------------------</P><P></P><P>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.</P><P></P><P>Thanks &amp; Regards,</P><P>Vidhya </P></BODY></HTML> Tue, 14 Aug 2018 07:37:18 GMT https://community.qlik.com/t5/QlikView/To-show-null-values-in-pivot-table/m-p/135920#M602404 vidhya91gct 2018-08-14T07:37:18Z Re: To show null values in pivot table https://community.qlik.com/t5/QlikView/To-show-null-values-in-pivot-table/m-p/135921#M602405 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Have any idea on the above scenario?</P><P></P><P>Thanks,</P><P>Vidhya</P></BODY></HTML> Tue, 14 Aug 2018 13:38:50 GMT https://community.qlik.com/t5/QlikView/To-show-null-values-in-pivot-table/m-p/135921#M602405 vidhya91gct 2018-08-14T13:38:50Z