Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. 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

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

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

Partner
Partner

Re: Filtering a dimension and renaming values

Nope,

i got an empty list box...

Re: Filtering a dimension and renaming values

Do you have a sample you can share?

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