topic How to represent dimension values horizontally? in QlikView https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961142#M329853 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have a requirement where in a table with a total of 4 columns are to be represented in a pivot table fashion which has to be accomplished in the script editor alone.The example tables are as follows</P><P></P><P>Original Table</P><P>Country&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dollar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500</P><P>UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Euros&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>INDIA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rupees&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P></P><P>Required Table1</P><P>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dollar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Euros&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rupees&nbsp;&nbsp;&nbsp;&nbsp; Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P>USA</P><P>UK</P><P>INDIA</P><P></P><P></P><P>When a country for example USA is selected,the table should be</P><P style="font-size: 13.3333px;">Required Table2</P><P style="font-size: 13.3333px;">Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dollar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500&nbsp;&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">USA</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Is it possible to get it in such a fashion?</P><P style="font-size: 13.3333px;">I have obtained the requirement until Required Table 1 using Generic Load, but there the values of one field became dimensions and I had to select those manually. My user requires the Code, Currency and Sales to be dynamic so that when in future if additional data is loaded, then the user doesn't need to select the dimensions again and again.</P></BODY></HTML> Tue, 29 Sep 2015 16:41:11 GMT Anonymous 2015-09-29T16:41:11Z How to represent dimension values horizontally? https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961142#M329853 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P>I have a requirement where in a table with a total of 4 columns are to be represented in a pivot table fashion which has to be accomplished in the script editor alone.The example tables are as follows</P><P></P><P>Original Table</P><P>Country&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales</P><P>USA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dollar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500</P><P>UK&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Euros&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000</P><P>INDIA&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rupees&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P></P><P>Required Table1</P><P>Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 002&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dollar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Euros&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Rupees&nbsp;&nbsp;&nbsp;&nbsp; Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2000&nbsp;&nbsp;&nbsp;&nbsp; 2500</P><P>USA</P><P>UK</P><P>INDIA</P><P></P><P></P><P>When a country for example USA is selected,the table should be</P><P style="font-size: 13.3333px;">Required Table2</P><P style="font-size: 13.3333px;">Country&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Code&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 001&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Currency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Dollar&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sales&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1500&nbsp;&nbsp;&nbsp;&nbsp; </P><P style="font-size: 13.3333px;">USA</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">Is it possible to get it in such a fashion?</P><P style="font-size: 13.3333px;">I have obtained the requirement until Required Table 1 using Generic Load, but there the values of one field became dimensions and I had to select those manually. My user requires the Code, Currency and Sales to be dynamic so that when in future if additional data is loaded, then the user doesn't need to select the dimensions again and again.</P></BODY></HTML> Tue, 29 Sep 2015 16:41:11 GMT https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961142#M329853 Anonymous 2015-09-29T16:41:11Z Re: How to represent dimension values horizontally? https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961143#M329854 <HTML><HEAD></HEAD><BODY><P>when you build your table, on the Presentation tab, you can check the 'Horizontal' check box</P></BODY></HTML> Tue, 29 Sep 2015 16:54:06 GMT https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961143#M329854 2015-09-29T16:54:06Z Re: How to represent dimension values horizontally? https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961144#M329855 <HTML><HEAD></HEAD><BODY><P>Hi Adam,</P><P>Thanks for the quick response but I need in the below fashion </P><P>Column name1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Values&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column name2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Values&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Column name3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Values</P></BODY></HTML> Wed, 30 Sep 2015 10:31:43 GMT https://community.qlik.com/t5/QlikView/How-to-represent-dimension-values-horizontally/m-p/961144#M329855 Anonymous 2015-09-30T10:31:43Z