topic Sorting data in ValueList for Qlik Sense in App Development https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294889#M27352 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am a new user of qlik sense and&nbsp; I require your help to understand the problems in the following two cases.</P><P></P><P>In the following bar chart I have used ValueList as measuring field because I had two measures to calculate and I needed them to be in this particular colors. However, once I am trying to sort the data in the bar by a particular measure (EngagementPCT) I am unable to do so. Instead of putting the value in descending order it is showing something like this:</P><P><IMG alt="Capture 2.JPG" class="jive-image image-1" src="/legacyfs/online/166963_Capture 2.JPG" style="height: 410px; width: 620px;" /></P><P><SPAN style="font-size: 10pt;">My question is can I sort the data by any of the measures from the ValueList in this particular case? If so how?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">My second question is if you look at the chart you will see category B has 0% of engagement (orange bar is absent). I also wanted to format <STRONG style="text-decoration: underline;">only</STRONG> this particular bar to show a precision up until two decimal point so that it shows the engagement bar. Is there a way to do it?I am attaching the excel and the app for your help. Any help regarding this will be much appreciated.Thanks in Advance! </SPAN></P></BODY></HTML> Thu, 15 Jun 2017 09:01:04 GMT Anonymous 2017-06-15T09:01:04Z Sorting data in ValueList for Qlik Sense https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294889#M27352 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am a new user of qlik sense and&nbsp; I require your help to understand the problems in the following two cases.</P><P></P><P>In the following bar chart I have used ValueList as measuring field because I had two measures to calculate and I needed them to be in this particular colors. However, once I am trying to sort the data in the bar by a particular measure (EngagementPCT) I am unable to do so. Instead of putting the value in descending order it is showing something like this:</P><P><IMG alt="Capture 2.JPG" class="jive-image image-1" src="/legacyfs/online/166963_Capture 2.JPG" style="height: 410px; width: 620px;" /></P><P><SPAN style="font-size: 10pt;">My question is can I sort the data by any of the measures from the ValueList in this particular case? If so how?</SPAN></P><P><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt;">My second question is if you look at the chart you will see category B has 0% of engagement (orange bar is absent). I also wanted to format <STRONG style="text-decoration: underline;">only</STRONG> this particular bar to show a precision up until two decimal point so that it shows the engagement bar. Is there a way to do it?I am attaching the excel and the app for your help. Any help regarding this will be much appreciated.Thanks in Advance! </SPAN></P></BODY></HTML> Thu, 15 Jun 2017 09:01:04 GMT https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294889#M27352 Anonymous 2017-06-15T09:01:04Z Re: Sorting data in ValueList for Qlik Sense https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294890#M27353 <HTML><HEAD></HEAD><BODY><P>Alter the Sort definition to be Avg(EngagementPCT). </P><P><IMG alt="grab1.tiff" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/167005_grab1.tiff" style="height: auto;" /></P><P><IMG alt="grab2.tiff" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/167006_grab2.tiff" style="height: 330px; width: 620px;" /></P></BODY></HTML> Thu, 15 Jun 2017 15:17:44 GMT https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294890#M27353 dan_sullivan 2017-06-15T15:17:44Z Re: Sorting data in ValueList for Qlik Sense https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294891#M27354 <HTML><HEAD></HEAD><BODY><P>Thanks a lot.. this solved the first issue <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> </P></BODY></HTML> Thu, 15 Jun 2017 16:27:50 GMT https://community.qlik.com/t5/App-Development/Sorting-data-in-ValueList-for-Qlik-Sense/m-p/1294891#M27354 Anonymous 2017-06-15T16:27:50Z