Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

danielrogra
New Contributor III

Variable names when filtering

Hello All

First of all, thank you for your time

I was wondering if there is a way to avoid this "issue" I have when filtering. Imagine I have a table like this

cm_a     name     cf_name

a               x               b

So I create a variable called Real name = cf_name. Then I create a dimension Real Name as following: $(Real name)

After all, when I filter using the dimension Real Name I can see the variable cf_name on the filter bar. Is there a way to see Real name instead of cf_name in the filter bar?

Thank you for your time

Daniel

Tags (1)
10 Replies
omarbensalem
Esteemed Contributor

Re: Variable names when filtering

Why do you need to create the Real Name as a variable?

Create it as a master dimension instead and then u can see its new name in the filter pane

danielrogra
New Contributor III

Re: Variable names when filtering

Hello Omar. Thank you for your quick reply.

I also did that but I see the same...I see the field name instead of the variable name...

arvind1494
Contributor III

Re: Variable names when filtering

dont use as a variable make it as a master itm

or while loading rename cf_name as a real_name

agigliotti
Honored Contributor II

Re: Variable names when filtering

could you please explain better what are you trying to achieve ?

danielrogra
New Contributor III

Re: Variable names when filtering

Thank you arvind.

When I make a master item it works in the same way, I see the name field instead of the master item...

omarbensalem
Esteemed Contributor

Re: Variable names when filtering

It's really a stupid thing to do (but it will work )

when u create uur master dimension, create it as follow:

if(cf_name=cf_name,cf_name)


name it Real name and it will appear as follow in the filter pane;


if u create it as cf_name, it will appear as cf_name..


example:


Capture.PNG

Capture.PNG

danielrogra
New Contributor III

Re: Variable names when filtering

Hello Andrea

I mean something like this: Captura.PNG

I want to see 'Name' instead of Cam_NM.....

Thank you!

danielrogra
New Contributor III

Re: Variable names when filtering

Thank you Omar!! It's a bit tricky but it seems that it works...Is that the only way?

Thank you very much indeed.

omarbensalem
Esteemed Contributor

Re: Variable names when filtering

I think so yes; well if that did the trick; please close the thread by makring the correct answer as correct and the one that've helped u as helpful; so that other community members would know this case is closed and have their answer if they do face such a situation !

Thanks