topic Re: Pivot Formatting in QlikView https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034187#M348820 <HTML><HEAD></HEAD><BODY><P>Not able to open....</P><P></P><P>Could you share your expected output? whta exactly you want?</P></BODY></HTML> Mon, 15 Feb 2016 10:20:02 GMT Anonymous 2016-02-15T10:20:02Z Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034186#M348819 <HTML><HEAD></HEAD><BODY><P>How to create the pivot table in format defined in excel ,where only gross divide on the basis of product name</P></BODY></HTML> Mon, 15 Feb 2016 10:18:33 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034186#M348819 2016-02-15T10:18:33Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034187#M348820 <HTML><HEAD></HEAD><BODY><P>Not able to open....</P><P></P><P>Could you share your expected output? whta exactly you want?</P></BODY></HTML> Mon, 15 Feb 2016 10:20:02 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034187#M348820 Anonymous 2016-02-15T10:20:02Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034188#M348821 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/114626_Capture.PNG" style="width: 620px; height: 130px;" /></P></BODY></HTML> Mon, 15 Feb 2016 10:31:51 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034188#M348821 2016-02-15T10:31:51Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034189#M348822 <HTML><HEAD></HEAD><BODY><P>Again not able to open...</P><P></P><P>You can use Pivot Table to get similar output...</P><P></P><P><STRONG>For these products which need to be like Column Fashion....Slicing &amp; Dicing feature is avail</STRONG><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Mon, 15 Feb 2016 10:35:57 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034189#M348822 Anonymous 2016-02-15T10:35:57Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034190#M348823 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Not able to open your excel</P><P></P><P>It is possible if</P><P>CampaignId, MappinID,Region,SubRegion,TotalQty,Covered %,No Of Pro,Total Product and Product is dimension</P><P>and</P><P>Gross Sales and Net Sales is Expression.</P><P></P><P>Regards</P></BODY></HTML> Mon, 15 Feb 2016 10:40:20 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034190#M348823 PrashantSangle 2016-02-15T10:40:20Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034191#M348824 <HTML><HEAD></HEAD><BODY><P>If I do that it will divide other expression on the basis of product name,,</P><P>But I want that only gross divide on the basis of product name</P></BODY></HTML> Mon, 15 Feb 2016 10:46:56 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034191#M348824 2016-02-15T10:46:56Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034192#M348825 <HTML><HEAD></HEAD><BODY><P>no</P></BODY></HTML> Mon, 15 Feb 2016 10:48:19 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034192#M348825 2016-02-15T10:48:19Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034193#M348826 <HTML><HEAD></HEAD><BODY><P>Well..Agreed as this is the default functionality in qlik.</P><P></P><P>Not sure whether we can achieve what you are asking for<IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>Lets wait for some more response, if this is possible</P></BODY></HTML> Mon, 15 Feb 2016 10:51:08 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034193#M348826 Anonymous 2016-02-15T10:51:08Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034194#M348827 <HTML><HEAD></HEAD><BODY><P>Hi Shweta,</P><P></P><P>Try to create a inline load with 3 to 4 rows and create an Excel by your own, better it will help us.</P><P></P><P>Thanks</P><P>Kiran kumar</P></BODY></HTML> Mon, 15 Feb 2016 10:55:01 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034194#M348827 kkkumar82 2016-02-15T10:55:01Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034195#M348828 <HTML><HEAD></HEAD><BODY><P>Why not you use custom format.</P><P>Plz come in more words</P></BODY></HTML> Mon, 15 Feb 2016 11:08:39 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034195#M348828 sujeetsingh 2016-02-15T11:08:39Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034196#M348829 <HTML><HEAD></HEAD><BODY><P>how to do that, can u explain with an example</P></BODY></HTML> Fri, 19 Feb 2016 10:09:14 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034196#M348829 2016-02-19T10:09:14Z Re: Pivot Formatting https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034197#M348830 <HTML><HEAD></HEAD><BODY><P>My intension was to create a excel sheet with data in one sheet and in other sheet please define your format.</P><P>So that we can help you in Qlik.</P><P></P><P></P><P>Thanks</P><P>Kiran </P></BODY></HTML> Fri, 19 Feb 2016 13:57:55 GMT https://community.qlik.com/t5/QlikView/Pivot-Formatting/m-p/1034197#M348830 kkkumar82 2016-02-19T13:57:55Z