topic Re: Value list in Pivot table in QlikView https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772892#M473162 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the attached file.</P><P></P><P>You need to switch the object to pivot table so you can drag the dimension horizontally.</P><P>Then you'll need only 1 expression instead of 2 where you assign the expression depending on the valuelist.</P></BODY></HTML> Wed, 19 Nov 2014 00:25:59 GMT 2014-11-19T00:25:59Z Value list in Pivot table https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772891#M473161 <HTML><HEAD></HEAD><BODY><P>So, here is my issue.</P><P>Please open the attached file named Test. If you see the table in the file,</P><P></P><P>1. all I want to list "Hire" and "Apllicant" into one column.</P><P></P><P>Or</P><P></P><P>2. put the dimension named "App &amp; Hire" to horizontal way. (I really need to learn this for later use)</P><P></P><P>Can anyone please teach me how I can do those two?</P></BODY></HTML> Wed, 19 Nov 2014 00:14:14 GMT https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772891#M473161 2014-11-19T00:14:14Z Re: Value list in Pivot table https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772892#M473162 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the attached file.</P><P></P><P>You need to switch the object to pivot table so you can drag the dimension horizontally.</P><P>Then you'll need only 1 expression instead of 2 where you assign the expression depending on the valuelist.</P></BODY></HTML> Wed, 19 Nov 2014 00:25:59 GMT https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772892#M473162 2014-11-19T00:25:59Z Re: Value list in Pivot table https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772893#M473163 <HTML><HEAD></HEAD><BODY><P>Perfect!</P><P>Thank you!</P></BODY></HTML> Thu, 20 Nov 2014 16:20:41 GMT https://community.qlik.com/t5/QlikView/Value-list-in-Pivot-table/m-p/772893#M473163 2014-11-20T16:20:41Z