Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. Register by February 29th to save $200. Learn More
Highlighted
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
Highlighted

Re: Filtering a dimension and renaming values

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
Highlighted

Re: Filtering a dimension and renaming values

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

Highlighted
Partner
Partner

Re: Filtering a dimension and renaming values

Nope,

i got an empty list box...

Highlighted

Re: Filtering a dimension and renaming values

Do you have a sample you can share?

Highlighted
Partner
Partner

Re: Filtering a dimension and renaming values

My fault,

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

now it works.

TY

Re: Filtering a dimension and renaming values

Awesome