topic sorted ddimension at pivot table in QlikView https://community.qlik.com/t5/QlikView/sorted-ddimension-at-pivot-table/m-p/208263#M1208241 <HTML><HEAD></HEAD><BODY><P>&lt;body&gt;&lt;p&gt;I am new with QlikView, as you will see.. &lt;/p&gt; &lt;p&gt;There is any way, I can choose an dimension with having to select it form the list of them?&lt;/p&gt; &lt;p&gt;In other words. I would like to use a pivot table, with "already" sorted one of the dimension. &lt;/p&gt; &lt;p&gt;&nbsp;&nbsp; &lt;v:textbox style="mso-next-textbox: #_x0000_s1028; mso-fit-shape-to-text: t;"&gt; &lt;table width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tbody&gt; &lt;tr&gt; &lt;td style="background-color: transparent; border: #d4d0c8;"&gt; &lt;div&gt; &lt;p style="margin: 0cm 0cm 0pt -72pt; text-indent: 72pt;" &gt;&lt;/v:formulas&gt;&lt;/p&gt; &lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;/v:textbox&gt;&lt;w:wrap type="square"&gt;&lt;/w:wrap&gt; &lt;v:textbox style="mso-next-textbox: #_x0000_s1028; mso-fit-shape-to-text: t;"&gt; &lt;table width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tbody&gt; &lt;tr&gt; &lt;td style="background-color: transparent; border: #d4d0c8;"&gt; &lt;div&gt; &lt;p style="margin: 0cm 0cm 0pt -72pt; text-indent: 72pt;" &gt;&lt;/v:formulas&gt;&lt;/p&gt; &lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;/v:textbox&gt;&lt;w:wrap type="square"&gt;&lt;/w:wrap&gt;&lt;/v:formulas&gt;&lt;/span&gt;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt;&lt;/body&gt;</P></BODY></HTML> Tue, 12 Jan 2010 02:20:19 GMT 2010-01-12T02:20:19Z sorted ddimension at pivot table https://community.qlik.com/t5/QlikView/sorted-ddimension-at-pivot-table/m-p/208263#M1208241 <HTML><HEAD></HEAD><BODY><P>&lt;body&gt;&lt;p&gt;I am new with QlikView, as you will see.. &lt;/p&gt; &lt;p&gt;There is any way, I can choose an dimension with having to select it form the list of them?&lt;/p&gt; &lt;p&gt;In other words. I would like to use a pivot table, with "already" sorted one of the dimension. &lt;/p&gt; &lt;p&gt;&nbsp;&nbsp; &lt;v:textbox style="mso-next-textbox: #_x0000_s1028; mso-fit-shape-to-text: t;"&gt; &lt;table width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tbody&gt; &lt;tr&gt; &lt;td style="background-color: transparent; border: #d4d0c8;"&gt; &lt;div&gt; &lt;p style="margin: 0cm 0cm 0pt -72pt; text-indent: 72pt;" &gt;&lt;/v:formulas&gt;&lt;/p&gt; &lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;/v:textbox&gt;&lt;w:wrap type="square"&gt;&lt;/w:wrap&gt; &lt;v:textbox style="mso-next-textbox: #_x0000_s1028; mso-fit-shape-to-text: t;"&gt; &lt;table width="100%" cellpadding="0" cellspacing="0"&gt; &lt;tbody&gt; &lt;tr&gt; &lt;td style="background-color: transparent; border: #d4d0c8;"&gt; &lt;div&gt; &lt;p style="margin: 0cm 0cm 0pt -72pt; text-indent: 72pt;" &gt;&lt;/v:formulas&gt;&lt;/p&gt; &lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;/tbody&gt; &lt;/table&gt; &lt;/v:textbox&gt;&lt;w:wrap type="square"&gt;&lt;/w:wrap&gt;&lt;/v:formulas&gt;&lt;/span&gt;&lt;/p&gt; &lt;p&gt;&nbsp;&lt;/p&gt;&lt;/body&gt;</P></BODY></HTML> Tue, 12 Jan 2010 02:20:19 GMT https://community.qlik.com/t5/QlikView/sorted-ddimension-at-pivot-table/m-p/208263#M1208241 2010-01-12T02:20:19Z sorted ddimension at pivot table https://community.qlik.com/t5/QlikView/sorted-ddimension-at-pivot-table/m-p/208264#M1208242 <HTML><HEAD></HEAD><BODY><P>Good Morning,</P><P>I think you have problem while sorting with two dimension in the table. Is it right?</P><P>I also had a same problem. To overcome join the two dimensions and create a hash code based on the join.</P><P>If for one dimension, do the same.</P><P>I don't know whether the hash code works for single dimension. Try it and tell you comment regarding this.</P><P>Regards,</P><P>R.Srinivasan</P></BODY></HTML> Tue, 12 Jan 2010 06:50:05 GMT https://community.qlik.com/t5/QlikView/sorted-ddimension-at-pivot-table/m-p/208264#M1208242 2010-01-12T06:50:05Z