topic Re: Pivot Problem in QlikView https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723764#M1054614 <HTML><HEAD></HEAD><BODY><P>Drag the dimension site (blue arrow) over qty you will get the table structure you want. Then in presentation tab of chart properties remove null and missing symbol to blank(by default shows - ).</P></BODY></HTML> Tue, 14 Oct 2014 13:58:16 GMT sivarajs 2014-10-14T13:58:16Z Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723761#M1054611 <HTML><HEAD></HEAD><BODY><P>My Qlikview Dashboard Raw Data Like</P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 204px;"><TBODY><TR><TD class="xl63" height="20" width="76">Item</TD><TD class="xl63" style="border-left: none;" width="64">Site</TD><TD class="xl63" style="border-left: none;" width="64">Qty</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Item 1</TD><TD class="xl63" style="border-top: none; border-left: none;">Site 1</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">4</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Item 1</TD><TD class="xl63" style="border-top: none; border-left: none;">Site 2</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl63" height="20" style="border-top: none;">Item 2</TD><TD class="xl63" style="border-top: none; border-left: none;">Site 1</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">6</TD></TR></TBODY></TABLE><P>and I want data in qlikview Like This Where 0 then show 0 when null then show blank.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 204px;"><TBODY><TR><TD class="xl65" height="20" width="76">Row Labels</TD><TD class="xl65" style="border-left: none;" width="64">Site 1</TD><TD class="xl65" style="border-left: none;" width="64">Site 2</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Item 1</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">4</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;">Item 2</TD><TD align="right" class="xl65" style="border-top: none; border-left: none;">6</TD><TD class="xl65" style="border-top: none; border-left: none;"></TD></TR></TBODY></TABLE><P></P><P>how to achieve this please suggest.</P></BODY></HTML> Tue, 14 Oct 2014 13:40:18 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723761#M1054611 vijayit43 2014-10-14T13:40:18Z Re: Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723762#M1054612 <HTML><HEAD></HEAD><BODY><P>Like this.</P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Tue, 14 Oct 2014 13:46:57 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723762#M1054612 ashfaq_haseeb 2014-10-14T13:46:57Z Re: Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723763#M1054613 <HTML><HEAD></HEAD><BODY><P>Hi Ashifaq,</P><P></P><P>Can you plz provide the code.i am unable to access this application right now.</P></BODY></HTML> Tue, 14 Oct 2014 13:53:27 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723763#M1054613 2014-10-14T13:53:27Z Re: Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723764#M1054614 <HTML><HEAD></HEAD><BODY><P>Drag the dimension site (blue arrow) over qty you will get the table structure you want. Then in presentation tab of chart properties remove null and missing symbol to blank(by default shows - ).</P></BODY></HTML> Tue, 14 Oct 2014 13:58:16 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723764#M1054614 sivarajs 2014-10-14T13:58:16Z Re: Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723765#M1054615 <HTML><HEAD></HEAD><BODY><P>how to achieve it</P></BODY></HTML> Tue, 14 Oct 2014 13:58:18 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723765#M1054615 vijayit43 2014-10-14T13:58:18Z Re: Re: Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723766#M1054616 <HTML><HEAD></HEAD><BODY><P>Check this</P></BODY></HTML> Tue, 14 Oct 2014 13:59:28 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723766#M1054616 ashfaq_haseeb 2014-10-14T13:59:28Z Re: Pivot Problem https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723767#M1054617 <HTML><HEAD></HEAD><BODY><P>Hi Ashfaq,</P><P></P><P>Thanks</P></BODY></HTML> Tue, 14 Oct 2014 14:03:48 GMT https://community.qlik.com/t5/QlikView/Pivot-Problem/m-p/723767#M1054617 2014-10-14T14:03:48Z