Filtering a dimension and renaming values

[gkluca82]

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

[sunny_talwar · Accepted solution]

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

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

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

[gkluca82]

Nope,

i got an empty list box...

[sunny_talwar]

Do you have a sample you can share?

[gkluca82]

My fault,

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

now it works.

TY

[sunny_talwar]

Awesome