Discussion board where members can get started with QlikView.
I have a list box which I would like to display without the first value and a delimeter.
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 01-04 Week 1 Of Jan. How can I do this?
Use this expression
View solution in original post
Please find the attached solution.
Go to List box properties and Sort tab.
Sort by expression to get the desired result.
The sorting is done, but how do I remove the "~" and values to the left in the front end?
Mine does not go away after usinmg the same expression as yours.
Thank you so much!