Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gkluca82
Partner - Contributor III
Partner - Contributor III

Filtering a dimension and renaming values

Hi everyone!

I've to filter the values on a filter pane in order to visualize only certain of them.

Ex:   i've a field called "Sorting" with values like A, B, C, D, ect ect.

How can i display only A and B on a filter pane?

and, how can i rename A and B in new text values?

Thanks in advance!

Luca

1 Solution

Accepted Solutions
sunny_talwar

May be like this in your list box or multi box expression:

If(Sorting = 'A', 'Text 1',

If(Sorting = 'B', 'Text 2'))

View solution in original post

5 Replies
sunny_talwar

May be like this in your list box or multi box expression:

If(Sorting = 'A', 'Text 1',

If(Sorting = 'B', 'Text 2'))

gkluca82
Partner - Contributor III
Partner - Contributor III
Author

Nope,

i got an empty list box...

sunny_talwar

Do you have a sample you can share?

gkluca82
Partner - Contributor III
Partner - Contributor III
Author

My fault,

that's correct! i was doing a very stupid error, case sensitive text values... LOL

now it works.

TY

sunny_talwar

Awesome