topic QlikView sorts the values ​​not in the correct alphabetical sequence in QlikView https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170517#M380522 <HTML><HEAD></HEAD><BODY><DIV class="tw-swapa"><SPAN lang="en">QlikView sorts the values ​​on the x - axis not in the correct alphabetical sequence. (in chart diagram)</SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en">In the sort setting, I have selected only alphabetical order A-Z. </SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en"></SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en">This is the order what I expect: </SPAN></DIV><DIV class="tw-swapa"><P>SG57 Prikuss </P><P><SPAN lang="en">SG5810 Bankenportal</SPAN></P><P>SG98 Edm</P><P></P></DIV><DIV class="tw-swapa"><SPAN lang="en"></SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en"></SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en">This is, how qlikview sort the values: </SPAN></DIV><DIV class="tw-swapa"><P>SG57 Prikuss </P><P>SG98 Edm</P><P>SG5810 Bankenportal</P><SPAN lang="en"></SPAN></DIV><P></P><P></P><P></P><P>Why ? Any Workaround ?</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 30 May 2016 12:33:23 GMT 2016-05-30T12:33:23Z QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170517#M380522 <HTML><HEAD></HEAD><BODY><DIV class="tw-swapa"><SPAN lang="en">QlikView sorts the values ​​on the x - axis not in the correct alphabetical sequence. (in chart diagram)</SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en">In the sort setting, I have selected only alphabetical order A-Z. </SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en"></SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en">This is the order what I expect: </SPAN></DIV><DIV class="tw-swapa"><P>SG57 Prikuss </P><P><SPAN lang="en">SG5810 Bankenportal</SPAN></P><P>SG98 Edm</P><P></P></DIV><DIV class="tw-swapa"><SPAN lang="en"></SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en"></SPAN></DIV><DIV class="tw-swapa"><SPAN lang="en">This is, how qlikview sort the values: </SPAN></DIV><DIV class="tw-swapa"><P>SG57 Prikuss </P><P>SG98 Edm</P><P>SG5810 Bankenportal</P><SPAN lang="en"></SPAN></DIV><P></P><P></P><P></P><P>Why ? Any Workaround ?</P><P></P><P>Thanks.</P></BODY></HTML> Mon, 30 May 2016 12:33:23 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170517#M380522 2016-05-30T12:33:23Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170518#M380523 <HTML><HEAD></HEAD><BODY><P>Would you be able to share a sample where it is not working? You can use a sort expression like this, but I would still think that Text sorting should work</P><P></P><P><STRONG>Match(FieldName, 'SG57 Prikuss', 'SG98 Edm', 'SG5810 Bankenportal')</STRONG></P></BODY></HTML> Mon, 30 May 2016 16:22:48 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170518#M380523 sunny_talwar 2016-05-30T16:22:48Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170519#M380524 <HTML><HEAD></HEAD><BODY><P>try sort expression instead alphabetical sorting</P><P></P><P>=match(Field,</P><P>'SG57 Prikuss' ,</P><P><SPAN lang="en">'SG5810 Bankenportal',</SPAN></P><P>'SG98 Edm')</P></BODY></HTML> Mon, 30 May 2016 16:24:54 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170519#M380524 Kushal_Chawda 2016-05-30T16:24:54Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170520#M380525 <HTML><HEAD></HEAD><BODY><P>But why would text sorting won't work <A _jive_internal="true" href="https://community.qlik.com/people/kush141087">kushal</A></P></BODY></HTML> Mon, 30 May 2016 16:33:17 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170520#M380525 sunny_talwar 2016-05-30T16:33:17Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170521#M380526 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>maybe helpful:</P><P></P><P><A href="https://community.qlik.com/thread/97800">Listbox - text sort not ASCII?</A></P><P></P><P><A href="https://community.qlik.com/thread/95340">Sorting Fields with special characters</A></P><P></P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 30 May 2016 20:24:27 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170521#M380526 MarcoWedel 2016-05-30T20:24:27Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170522#M380527 <HTML><HEAD></HEAD><BODY><P>Edit: Doesn't work</P><P></P><P><SPAN style="text-decoration: line-through;">Hi,</SPAN></P><P></P><P><SPAN style="text-decoration: line-through;">one solution could be to use your fieldname as sorting expression:</SPAN></P><P></P><P><IMG __jive_id="126275" alt="QlikCommunity_Thread_218826_Pic1.JPG" class="jive-image image-1" height="292" src="https://community.qlik.com/legacyfs/online/126275_QlikCommunity_Thread_218826_Pic1.JPG" style="height: 292px; width: 161.323px;" width="161" /></P><P><IMG __jive_id="126276" alt="QlikCommunity_Thread_218826_Pic2.JPG" class="jive-image image-2" height="201" src="https://community.qlik.com/legacyfs/online/126276_QlikCommunity_Thread_218826_Pic2.JPG" style="height: 200.573px; width: 323px;" width="323" /></P><P></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 30 May 2016 20:27:18 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170522#M380527 MarcoWedel 2016-05-30T20:27:18Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170523#M380528 <HTML><HEAD></HEAD><BODY><P>What happens if you are using a load order that is not well sorted, Marco <IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" />?</P></BODY></HTML> Mon, 30 May 2016 21:45:34 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170523#M380528 swuehl 2016-05-30T21:45:34Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170524#M380529 <HTML><HEAD></HEAD><BODY><P>Good one. </P><P>Guess I should have read the linked threads myself.</P><P></P><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/blush.png" /></P><P></P><P>thanks</P><P></P><P>Marco</P></BODY></HTML> Mon, 30 May 2016 22:07:02 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170524#M380529 MarcoWedel 2016-05-30T22:07:02Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170525#M380530 <HTML><HEAD></HEAD><BODY><P><IMG alt="2016-05-31 00_44_36-QlikView x64 - [C__Users_Stefan_Downloads_QlikCommunity_Thread_218826_2.qvw].png" class="jive-image image-1" src="/legacyfs/online/126280_2016-05-31 00_44_36-QlikView x64 - [C__Users_Stefan_Downloads_QlikCommunity_Thread_218826_2.qvw].png" style="height: 439px; width: 620px;" />What about this?</P></BODY></HTML> Mon, 30 May 2016 22:47:03 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170525#M380530 swuehl 2016-05-30T22:47:03Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170526#M380531 <HTML><HEAD></HEAD><BODY><P>very good</P><P>and interesting too</P><P></P><P>just was about to post this when I read your answer ...</P><P></P><P></P><P>At first I tried with some conversion to concatenated ASCII codes</P><P><IMG alt="QlikCommunity_Thread_218826_Pic3.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/126290_QlikCommunity_Thread_218826_Pic3.JPG" style="max-width: 620px; height: auto;" /></P><P></P><P>when I noticed that Rank descending would be sufficient.</P><P></P><P></P><P>thanks</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 30 May 2016 22:56:11 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170526#M380531 MarcoWedel 2016-05-30T22:56:11Z Re: QlikView sorts the values not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170527#M380532 <HTML><HEAD></HEAD><BODY><P>Yeah, I only recently (way after the referenced threads) learned that we can actually rank text values..</P></BODY></HTML> Mon, 30 May 2016 23:00:11 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170527#M380532 swuehl 2016-05-30T23:00:11Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170528#M380533 <HTML><HEAD></HEAD><BODY><P>I guess I never tried before this thread.</P><P>There's always something to learn around here ...</P><P></P><P>Marco</P></BODY></HTML> Mon, 30 May 2016 23:05:20 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170528#M380533 MarcoWedel 2016-05-30T23:05:20Z Re: QlikView sorts the values ​​not in the correct alphabetical sequence https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170529#M380534 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>please tell me the scenario of sequenece</P></BODY></HTML> Wed, 23 Nov 2016 05:48:55 GMT https://community.qlik.com/t5/QlikView/QlikView-sorts-the-values-not-in-the-correct-alphabetical/m-p/1170529#M380534 Anonymous 2016-11-23T05:48:55Z