Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
gkluca82
Partner
Partner

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'))

View solution in original post

gkluca82
Partner
Partner
Author

Nope,

i got an empty list box...

sunny_talwar

Do you have a sample you can share?

gkluca82
Partner
Partner
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