Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Hidding value in Field


Hi All

I have a list box which I would like to display without the first value and a delimeter.

2015-02-03_18-21-51.png

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?

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Use this expression

=mid(F1,Index(F1,'~')+1)

View solution in original post

4 Replies
Highlighted
Creator III
Creator III

Please find the attached solution.

Go to List box properties and Sort tab.

Sort by expression to get the desired result.

Not applicable

Hi

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.

Highlighted
Creator III
Creator III

Use this expression

=mid(F1,Index(F1,'~')+1)

View solution in original post

Highlighted
Not applicable

Thank you so much!