topic Re: Hidding value in Field in QlikView https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818282#M1030243 <HTML><HEAD></HEAD><BODY><P>Thank you so much! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 Feb 2015 18:08:53 GMT 2015-02-03T18:08:53Z Hidding value in Field https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818278#M1030239 <HTML><HEAD></HEAD><BODY><P><BR />Hi All</P><P></P><P>I have a list box which I would like to display without the first value and a delimeter.</P><P></P><P><IMG alt="2015-02-03_18-21-51.png" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/77017_2015-02-03_18-21-51.png" style="height: auto;" /></P><P></P><P> I would like to sort the field by the the value to the left of "~" sign (Week), then only display data to the right right of the "~" in the front end. e.g <STRONG>01-04 Week 1 Of Jan. </STRONG>How can I do this?</P></BODY></HTML> Tue, 03 Feb 2015 16:29:00 GMT https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818278#M1030239 2015-02-03T16:29:00Z Re: Hidding value in Field https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818279#M1030240 <HTML><HEAD></HEAD><BODY><P>Please find the attached solution.</P><P></P><P>Go to List box properties and Sort tab.</P><P></P><P>Sort by expression to get the desired result.</P></BODY></HTML> Tue, 03 Feb 2015 17:36:03 GMT https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818279#M1030240 reshmakala 2015-02-03T17:36:03Z Re: Hidding value in Field https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818280#M1030241 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The sorting is done, but how do I remove the "~" and values to the left in the front end?</P><P>Mine does not go away after usinmg the same expression as yours.</P></BODY></HTML> Tue, 03 Feb 2015 17:53:52 GMT https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818280#M1030241 2015-02-03T17:53:52Z Re: Hidding value in Field https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818281#M1030242 <HTML><HEAD></HEAD><BODY><P>Use this expression</P><P></P><P><STRONG>=mid(F1,Index(F1,'~')+1)</STRONG></P></BODY></HTML> Tue, 03 Feb 2015 17:57:47 GMT https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818281#M1030242 reshmakala 2015-02-03T17:57:47Z Re: Hidding value in Field https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818282#M1030243 <HTML><HEAD></HEAD><BODY><P>Thank you so much! <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 03 Feb 2015 18:08:53 GMT https://community.qlik.com/t5/QlikView/Hidding-value-in-Field/m-p/818282#M1030243 2015-02-03T18:08:53Z