topic Re: Sorting in QlikView https://community.qlik.com/t5/QlikView/Sorting/m-p/81533#M768954 <HTML><HEAD></HEAD><BODY><P>Not sure I understand... your field contains more than just those numbers... how would you want the overall sort to look like?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204799_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 11 Jun 2018 11:13:51 GMT sunny_talwar 2018-06-11T11:13:51Z Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/81531#M768952 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P>Please find the ttachment of the QVW file . </P><P>I have a filed called filter ... and i am going to use it as filter but i want the sorting order&nbsp; like below</P><P>18.1</P><P>18.2</P><P>18.2</P><P>18.4</P><P>18.5</P><P>18.6</P><P>18.7</P><P>........ and so on ..Currently everything is combining very difficult to find the proper order </P><P>Please suggest some way </P><P></P><P>Thaks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/81531#M768952 smilingjohn 2020-11-25T16:16:04Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/81532#M768953 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>Please try below way it may help you</P><P><STRONG>Data:</STRONG></P><P><STRONG>Load * Inline [</STRONG></P><P></P><P><STRONG>Data</STRONG></P><P><STRONG>18.1</STRONG></P><P><STRONG>18.2</STRONG></P><P><STRONG>18.2</STRONG></P><P><STRONG>18.4</STRONG></P><P><STRONG>18.5</STRONG></P><P><STRONG>18.6</STRONG></P><P><STRONG>18.7];</STRONG></P><P></P><P><STRONG>Load </STRONG></P><P><STRONG>mid(Data,4) as Sortnumber </STRONG></P><P><STRONG>Resident Data;</STRONG></P><P></P><P></P><P>Exit Script;</P><P></P><P>Thanks,</P><P>Arvind Patil</P></BODY></HTML> Mon, 11 Jun 2018 11:11:02 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/81532#M768953 arvind_patil 2018-06-11T11:11:02Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/81533#M768954 <HTML><HEAD></HEAD><BODY><P>Not sure I understand... your field contains more than just those numbers... how would you want the overall sort to look like?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204799_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 11 Jun 2018 11:13:51 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/81533#M768954 sunny_talwar 2018-06-11T11:13:51Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/81534#M768955 <HTML><HEAD></HEAD><BODY><P>Hi sunny </P><P>Yes it has numbers as well as text .</P><P>But I want to display first ..</P><P>18.1</P><P>8.2 </P><P>.</P><P>.</P><P>.and so on and then the text ..</P><P>Thanks </P></BODY></HTML> Mon, 11 Jun 2018 15:37:22 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/81534#M768955 smilingjohn 2018-06-11T15:37:22Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/81535#M768956 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try loading the field using the <A href="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterpretationFunctions/Text.htm" title="https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/InterpretationFunctions/Text.htm">Text()</A>‌ function:</P><P></P><P><IMG alt="QlikCommunity_Thread_304391_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204875_QlikCommunity_Thread_304391_Pic1.JPG" style="height: auto; width: auto;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 11 Jun 2018 20:18:57 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/81535#M768956 MarcoWedel 2018-06-11T20:18:57Z Re: Sorting https://community.qlik.com/t5/QlikView/Sorting/m-p/81536#M768957 <HTML><HEAD></HEAD><BODY><P><STRONG style="font-size: 11.7px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><A href="https://community.qlik.com/people/marcowedel">marcowedel</A>‌'s </STRONG>solution is working.</P><P></P><P>Load Filter,Text(Filter) as Filter_Text inline [</P><P>Filter</P><P>18.06</P><P>18.05</P><P>18.04</P><P>18.6</P><P>18.5</P><P>18.4</P><P>DAILY_OLL_CERTD_0508</P><P>DAILY_OLL_CERTD_0520</P><P>DAILY_OLL_CERTD_0530</P><P>DAILY_OLL_PKGE_0514</P><P>DAILY_OLL_CERTD_0524</P><P>DAILY_OLL_CERTD_0527</P><P>DAILY_OLL_CERTD_0507</P><P>DAILY_OLL_CERTC_0604</P><P>DAILY_OLL_CERTD_0604</P><P>DAILY_OLL_CERTC_0603</P><P>DAILY_OLL_CERTC_0605</P><P>DAILY_OLL_CERTD_0506</P><P>DAILY_OLL_CERTC_0607</P><P>DAILY_OLL_PKGE_0507</P><P>DAILY_OLL_PKGE_0508</P><P>DAILY_OLL_CERTD_0607</P><P>DAILY_OLL_CERTC_0524</P><P>DAILY_OLL_PKGE_0509</P><P>DAILY_OLL_PKGE_0513</P><P>DAILY_OLL_PKGE_0510</P><P>DAILY_OLL_PKGE_0506</P><P>DAILY_OLL_PKGE_0429</P><P>DAILY_OLL_PKGE_0503</P><P>DAILY_OLL_P220_0523</P><P>DAILY_OLL_PKGE_0430</P><P>DAILY_OLL_PKGE_0502</P><P>DAILY_OLL_PKGE_0501</P><P>18.3.05</P><P>18.6.2</P><P>Adhoc_03_WPIL_CERT</P><P>18.6.1</P><P>18.6_Sanity</P><P>1805_PUT14</P><P>DAILY_OLL_CERTC_0508</P><P>18.06.01</P><P>18.5.1</P><P>18.5.5</P><P>18.4.2</P><P>18.5.1_Trial</P><P>18.5.4</P><P>18.5.2</P><P>1805_CERT_PUT14</P><P>Adhoc_PUT14_Mano</P><P>Adhoc_03_WPIL_TSTS</P><P>Adhoc_PNR_FOP_TSTS</P><P>Adhoc_Sprint11_Newscripts</P><P>DAILY_OLL_CERTC_0507</P><P>DAILY_OLL_CERTC_0506</P><P>Adhoc_CMT24012</P><P>Adhoc_ACPMXA_QDC_18MAY</P><P>Adhoc_CMT23507_SchedChange</P><P>Adhoc_ACPMXA_QDC_15MAY</P><P>Adhoc_ACPMXA_QDC_22MAY</P><P>Adhoc_ACPMXA_QDC_23MAY</P><P>Adhoc_ACPMXA_QDC_22MAYGDS</P><P>DAILY_OLL_CERTD_0603</P><P>DAILY_OLL_TSTSB_0508</P><P>DAILY_OLL_TSTSB_0515</P><P>DAILY_OLL_TSTSB_0506</P><P>DAILY_OLL_TSTSB_0509</P><P>DAILY_OLL_TSTSB_0514</P><P>DAILY_OLL_TSTSB_0510</P><P>DAILY_OLL_TSTSA_0527</P><P>DAILY_OLL_TSTSB_0503</P><P>DAILY_OLL_TSTSA_0530</P><P>DAILY_OLL_TSTSA_0607</P><P>DAILY_OLL_TSTSA_0529</P><P>DAILY_OLL_TSTSA_0531</P><P>DAILY_OLL_TSTSA_0606</P><P>DAILY_OLL_TSTSA_0603</P><P>DAILY_OLL_TSTSA_0604</P><P>DAILY_OLL_TSTSB_0513</P><P>LATAM_18.5_FALLBACKSEG_CERT</P><P>DAILY_OLL_TSTSB_0520</P><P>LATAM_18.5_FALLBACKSEG</P><P>LATAM_Refactoring</P><P>18.4.3</P><P>std_acs</P><P>std_airlines</P><P>LATAM_18.5_Adhoc</P><P>DAILY_OLL_TSTSB_0528</P><P>DAILY_OLL_TSTSB_0605</P><P>DAILY_OLL_TSTSB_0522</P><P>DAILY_OLL_TSTSB_0530</P><P>DAILY_OLL_TSTSB_0603</P><P>DAILY_OLL_TSTSB_0531</P><P>DAILY_OLL_PKGE_0607</P><P>DAILY_OLL_PKGE_0528</P><P>DAILY_OLL_PKGE_0604</P><P>DAILY_OLL_PKGE_0527</P><P>DAILY_OLL_PKGE_0529</P><P>DAILY_OLL_PKGE_0603</P><P>DAILY_OLL_PKGE_0530</P><P>DAILY_OLL_PKGE_0531</P><P>DAILY_OLL_TSTSA_0523</P><P>DAILY_OLL_PKGE_0517</P><P>DAILY_OLL_PKGE_0523</P><P>DAILY_OLL_PKGE_0516</P><P>DAILY_OLL_PKGE_0520</P><P>DAILY_OLL_PKGE_0522</P><P>DAILY_OLL_PKGE_0521</P><P>DAILY_OLL_PKGE_0524</P><P>DAILY_OLL_TSTSA_0513</P><P>DAILY_OLL_PKGE_0605</P><P>DAILY_OLL_TSTSA_0510</P><P>DAILY_OLL_TSTSA_0514</P><P>DAILY_OLL_TSTSA_0520</P><P>DAILY_OLL_TSTSA_0515</P><P>DAILY_OLL_TSTSA_0516</P><P>DAILY_OLL_TSTSA_0509</P><P>DAILY_OLL_PKGE_0515</P><P>DAILY_OLL_TSTSA_0508</P><P>DAILY_OLL_PKGE_0606</P><P>DAILY_OLL_TSTSA_0502</P><P>DAILY_OLL_TSTSA_0506</P><P>DAILY_OLL_TSTSA_0503</P><P>];</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/204880_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Tue, 12 Jun 2018 02:04:17 GMT https://community.qlik.com/t5/QlikView/Sorting/m-p/81536#M768957 qlikviewwizard 2018-06-12T02:04:17Z