topic Extra/Hide dimension in QlikView https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832465#M292893 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>In my below report I need 2010 column which is not a part of dimension Stage1 &amp; Stage2. How can I as Below please?</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Stage1&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Stage2&nbsp;&nbsp;&nbsp; |</P><P>&nbsp; 2010 |&nbsp;&nbsp; 2011 | 2012 |&nbsp; 2011 | 2012 |</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 11&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; |&nbsp;&nbsp; 18&nbsp;&nbsp; | </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 13&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp; |&nbsp;&nbsp; 12&nbsp; |</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 19&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp; |&nbsp;&nbsp; 17&nbsp;&nbsp; | as below</P><P></P><P> <IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88442_Capture1.PNG" style="height: 218px; width: 620px;" /></P><P>Sorting above as 1,2,3 with removing all Xs</P><P>QV attached</P><P></P><P>Thanks</P><P></P><P>&nbsp; </P><P> </P></BODY></HTML> Thu, 04 Jun 2015 23:38:46 GMT Anonymous 2015-06-04T23:38:46Z Extra/Hide dimension https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832465#M292893 <HTML><HEAD></HEAD><BODY><P>Hi Community</P><P></P><P>In my below report I need 2010 column which is not a part of dimension Stage1 &amp; Stage2. How can I as Below please?</P><P></P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Stage1&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Stage2&nbsp;&nbsp;&nbsp; |</P><P>&nbsp; 2010 |&nbsp;&nbsp; 2011 | 2012 |&nbsp; 2011 | 2012 |</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 11&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; |&nbsp;&nbsp; 18&nbsp;&nbsp; | </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 13&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp; |&nbsp;&nbsp; 12&nbsp; |</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 19&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp; |&nbsp;&nbsp; 17&nbsp;&nbsp; | as below</P><P></P><P> <IMG alt="Capture1.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88442_Capture1.PNG" style="height: 218px; width: 620px;" /></P><P>Sorting above as 1,2,3 with removing all Xs</P><P>QV attached</P><P></P><P>Thanks</P><P></P><P>&nbsp; </P><P> </P></BODY></HTML> Thu, 04 Jun 2015 23:38:46 GMT https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832465#M292893 Anonymous 2015-06-04T23:38:46Z Re: Extra/Hide dimension https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832466#M292894 <HTML><HEAD></HEAD><BODY><P>Satish,</P><P></P><P>You dont have common key for S9 in table S1. Find the attached qlikview file.</P><P></P><P><IMG alt="Join issue.bmp" class="jive-image image-1" src="/legacyfs/online/88438_Join issue.bmp" style="height: auto;" /></P></BODY></HTML> Fri, 05 Jun 2015 01:40:19 GMT https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832466#M292894 Siva_Sankar 2015-06-05T01:40:19Z Re: Extra/Hide dimension https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832467#M292895 <HTML><HEAD></HEAD><BODY><P>Hi Siva</P><P></P><P>I appreciate your answer, even after creating S9 common key, report does not fulfil the requirement Like</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Stage1&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; Stage2&nbsp;&nbsp;&nbsp; |&nbsp; </P><P>&nbsp; 2010 |&nbsp;&nbsp; 2011 | 2012 |&nbsp; 2011 | 2012 |</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 4&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 11&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 8&nbsp;&nbsp; |&nbsp;&nbsp; 18&nbsp;&nbsp; | </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 6&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 13&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp; |&nbsp;&nbsp; 12&nbsp; |</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 19&nbsp; |&nbsp;&nbsp;&nbsp;&nbsp; 7&nbsp;&nbsp; |&nbsp;&nbsp; 17&nbsp;&nbsp; |</P><P></P><P>As I want in your report(exactly as above)</P><P>1. Hide header Stage9</P><P>2. I need 2010 column as first.</P><P>3. Hide 2010 under Stage1 &amp; Stage2</P><P></P><P>Thanks for your quick answer</P></BODY></HTML> Fri, 05 Jun 2015 12:58:33 GMT https://community.qlik.com/t5/QlikView/Extra-Hide-dimension/m-p/832467#M292895 Anonymous 2015-06-05T12:58:33Z