topic Pivot Help in QlikView https://community.qlik.com/t5/QlikView/Pivot-Help/m-p/124609#M18938 <HTML><HEAD></HEAD><BODY><P>hi Communtiy,</P><P></P><P>I have one mapping file but out of this we need to create one additional expression which is required to come under main expression as 0 and it should come even if we suppress null.</P><P></P><P>Desired output</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207355_Capture.JPG" style="height: auto;" /></P><P></P><P></P><P>if we add ADR then it is going as main like x/y.</P><P></P><P>added mapping file and qv.</P><P></P><P>Please help if you got some expression to handle.</P><P></P><P>_Priya</P></BODY></HTML> Mon, 09 Jul 2018 15:23:36 GMT priyarane 2018-07-09T15:23:36Z Pivot Help https://community.qlik.com/t5/QlikView/Pivot-Help/m-p/124609#M18938 <HTML><HEAD></HEAD><BODY><P>hi Communtiy,</P><P></P><P>I have one mapping file but out of this we need to create one additional expression which is required to come under main expression as 0 and it should come even if we suppress null.</P><P></P><P>Desired output</P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/207355_Capture.JPG" style="height: auto;" /></P><P></P><P></P><P>if we add ADR then it is going as main like x/y.</P><P></P><P>added mapping file and qv.</P><P></P><P>Please help if you got some expression to handle.</P><P></P><P>_Priya</P></BODY></HTML> Mon, 09 Jul 2018 15:23:36 GMT https://community.qlik.com/t5/QlikView/Pivot-Help/m-p/124609#M18938 priyarane 2018-07-09T15:23:36Z