Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

gkluca82
New 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
MVP
MVP

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

5 Replies
MVP
MVP

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

gkluca82
New Contributor III

Re: Filtering a dimension and renaming values

Nope,

i got an empty list box...

MVP
MVP

Re: Filtering a dimension and renaming values

Do you have a sample you can share?

gkluca82
New Contributor III

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

MVP
MVP

Re: Filtering a dimension and renaming values

Awesome