topic Re: Extractable rows and columns in pivot or straight table in QlikView https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699916#M252662 <HTML><HEAD></HEAD><BODY><P>Can you explain your requirement with example?</P></BODY></HTML> Fri, 26 Sep 2014 02:30:20 GMT anbu1984 2014-09-26T02:30:20Z Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699915#M252661 <HTML><HEAD></HEAD><BODY><P>Hi all</P><P></P><P>Can anybody provide me QV sample in that user can have control to select ROWS, COLUMNS &amp; CALCUTAED FIELDS</P><P></P><P>for Pivot or Straight table</P><P></P><P>Thanking you in advance</P><P>Satish</P></BODY></HTML> Thu, 25 Sep 2014 20:59:05 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699915#M252661 Anonymous 2014-09-25T20:59:05Z Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699916#M252662 <HTML><HEAD></HEAD><BODY><P>Can you explain your requirement with example?</P></BODY></HTML> Fri, 26 Sep 2014 02:30:20 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699916#M252662 anbu1984 2014-09-26T02:30:20Z Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699917#M252663 <HTML><HEAD></HEAD><BODY><P>Let say I have sales details as below</P><P></P><P>&nbsp;&nbsp; Type-&gt;&nbsp;&nbsp; <STRONG>Garments&nbsp;&nbsp; Electronics&nbsp;&nbsp; Mobile&nbsp;&nbsp; Automobile</STRONG></P><P>Country</P><P>USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</P><P>Canada&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 11&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 22&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 33&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4</P><P>Mexico&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 101&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 202&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 303&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 404</P><P>UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 111&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 222&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 333&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 444</P><P></P><P>Now out of above I should able to select countries from List box so only those populated<BR />I should also able to select Type so only those calcutaion part appear in Pivot/Straight table</P><P></P><P>Thanks for reply</P></BODY></HTML> Fri, 26 Sep 2014 19:25:44 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699917#M252663 Anonymous 2014-09-26T19:25:44Z Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699918#M252664 <HTML><HEAD></HEAD><BODY><P>However, If you select in listbox the same thing will appear in the chart, do you mean to achieve it in chart itself without a listbox?</P></BODY></HTML> Fri, 26 Sep 2014 20:01:14 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699918#M252664 2014-09-26T20:01:14Z Re: Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699919#M252665 <HTML><HEAD></HEAD><BODY><P>Check this</P></BODY></HTML> Sat, 27 Sep 2014 02:13:09 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699919#M252665 anbu1984 2014-09-27T02:13:09Z Re: Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699920#M252666 <HTML><HEAD></HEAD><BODY><P>Yes, without Listbox</P></BODY></HTML> Mon, 29 Sep 2014 16:44:36 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699920#M252666 Anonymous 2014-09-29T16:44:36Z Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699921#M252667 <HTML><HEAD></HEAD><BODY><P>Without listbox for expressions??</P></BODY></HTML> Mon, 29 Sep 2014 16:52:54 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699921#M252667 anbu1984 2014-09-29T16:52:54Z Re: Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699922#M252668 <HTML><HEAD></HEAD><BODY><P>Hi Anbu</P><P></P><P>I do not see any message when you say Check this</P><P></P><P>Sorry for inconvi</P><P></P><P>Thanks</P><P><BR /> </P></BODY></HTML> Tue, 30 Sep 2014 17:38:07 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699922#M252668 Anonymous 2014-09-30T17:38:07Z Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699923#M252669 <HTML><HEAD></HEAD><BODY><P>Did you check my qvw above?</P></BODY></HTML> Tue, 30 Sep 2014 18:08:55 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699923#M252669 anbu1984 2014-09-30T18:08:55Z Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699924#M252670 <HTML><HEAD></HEAD><BODY><P>Hi Anbu</P><P></P><P>There is no attached QVW here </P></BODY></HTML> Thu, 02 Oct 2014 14:30:18 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699924#M252670 Anonymous 2014-10-02T14:30:18Z Re: Re: Extractable rows and columns in pivot or straight table https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699925#M252671 <HTML><HEAD></HEAD><BODY><P>Check this app</P></BODY></HTML> Fri, 03 Oct 2014 05:52:37 GMT https://community.qlik.com/t5/QlikView/Extractable-rows-and-columns-in-pivot-or-straight-table/m-p/699925#M252671 anbu1984 2014-10-03T05:52:37Z