topic Re: Set Reference visualization (Dynamic Dimensions) in QlikView https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680055#M538231 <HTML><HEAD></HEAD><BODY><P>Ashfaq, thanks for your reply - but I don't see any difference.</P><P>Doing step 1 to step 3 shows the same weird sort order.</P><P></P><P>Regards,</P><P>Florian</P></BODY></HTML> Thu, 25 Sep 2014 09:21:42 GMT pennetzdorfer 2014-09-25T09:21:42Z Set Reference visualization (Dynamic Dimensions) https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680052#M538223 <HTML><HEAD></HEAD><BODY><P>I've got the following bar chart:</P><UL><LI>Dynamic Dimension:&nbsp; <SPAN style="font-family: 'courier new', courier;">$(=DimField) </SPAN><EM>... allows switching between ValueOld and ValueNew</EM></LI><LI>Expression:&nbsp; <SPAN style="font-family: 'courier new', courier;">count(distinct ItemID)</SPAN></LI></UL><P></P><P>Now I'm using the "<STRONG>Set Reference</STRONG>" option to compare ValueOld vs. ValueNew. But unfortunately the sorting gets confused ...</P><P>Does anyone have an idea? Please find the attached qvw file.</P><P></P><P>Regards,</P><P>Florian</P><P><IMG alt="SetReference.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/67526_SetReference.png" style="width: 620px; height: 366px;" /></P></BODY></HTML> Wed, 24 Sep 2014 08:22:52 GMT https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680052#M538223 pennetzdorfer 2014-09-24T08:22:52Z Re: Set Reference visualization (Dynamic Dimensions) https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680053#M538226 <HTML><HEAD></HEAD><BODY><P>Unfortunately it looks like a "feature" ...</P><P></P><P>- Marcus</P></BODY></HTML> Thu, 25 Sep 2014 09:08:56 GMT https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680053#M538226 marcus_sommer 2014-09-25T09:08:56Z Re: Set Reference visualization (Dynamic Dimensions) https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680054#M538228 <HTML><HEAD></HEAD><BODY><P>Check this.</P><P></P><P></P><P>Regards</P><P>ASHFAQ</P></BODY></HTML> Thu, 25 Sep 2014 09:17:29 GMT https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680054#M538228 ashfaq_haseeb 2014-09-25T09:17:29Z Re: Set Reference visualization (Dynamic Dimensions) https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680055#M538231 <HTML><HEAD></HEAD><BODY><P>Ashfaq, thanks for your reply - but I don't see any difference.</P><P>Doing step 1 to step 3 shows the same weird sort order.</P><P></P><P>Regards,</P><P>Florian</P></BODY></HTML> Thu, 25 Sep 2014 09:21:42 GMT https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680055#M538231 pennetzdorfer 2014-09-25T09:21:42Z Re: Set Reference visualization (Dynamic Dimensions) https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680056#M538233 <HTML><HEAD></HEAD><BODY><P>You have to manipulate the load order, to achieve this, see changes in loadscript.</P></BODY></HTML> Thu, 25 Sep 2014 12:15:04 GMT https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680056#M538233 kji 2014-09-25T12:15:04Z Re: Set Reference visualization (Dynamic Dimensions) https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680057#M538234 <HTML><HEAD></HEAD><BODY><P>Hi Florian</P><P>Is this what you're trying to achieve? If so :-</P><P style="font-size: 13.3333330154419px;">Change the Sort order of your chart. </P><P style="font-size: 13.3333330154419px;">Currently you are sorting by Numeric Value Ascending.</P><P style="font-size: 13.3333330154419px;">Sort by Y-Value Ascending.</P><P><IMG alt="setrefviz.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/92224_setrefviz.png" style="height: auto;" /></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">regards</P><P style="font-size: 13.3333330154419px;">Paulo</P></BODY></HTML> Wed, 08 Jul 2015 08:35:17 GMT https://community.qlik.com/t5/QlikView/Set-Reference-visualization-Dynamic-Dimensions/m-p/680057#M538234 2015-07-08T08:35:17Z