Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

ClementByr
New Contributor III

Keep a dimension name in a selection box

Hello everyone,

I have created a custom dimension in the storyboard called CREATION_DATE.year which is a formula to keep only the year value in the dimension CREATION_DATE.

Here is the formula: CREATION_DATE.year=Year(Date#([CREATION_DATE], 'YYYY/MM/DD hh:mm:ss'))

I have created a filter CREATION_DATE.year, but I realised after my selection that the selection box on the top show the formula and not the dimension name CREATION_DATE.year.

Selection.png

Do you know a solution to fix this problem ? Many thanks.

Best regards.

1 Solution

Accepted Solutions
Highlighted
ajaykakkar93
Contributor III

Re: Keep a dimension name in a selection box

hi,

In attached application refer sheet "Keep a dimension name in Filter" hope you requirement is solved

Note : i have used the same method i have mentioned in my previous reply

Regards & Thanks,
Ajay Kakkar
ajaykakkar93@gmail.com
4 Replies
ajaykakkar93
Contributor III

Re: Keep a dimension name in a selection box

Hi,

I have a idea, what you can do is create a master measure in qlik sense with same expression name the master with desired name your issue will be solved.

If you are still facing an issue share a sample app I'll try to solve it in same app.

Regards & Thanks,
Ajay Kakkar
ajaykakkar93@gmail.com
Highlighted
ajaykakkar93
Contributor III

Re: Keep a dimension name in a selection box

hi,

In attached application refer sheet "Keep a dimension name in Filter" hope you requirement is solved

Note : i have used the same method i have mentioned in my previous reply

Regards & Thanks,
Ajay Kakkar
ajaykakkar93@gmail.com
ClementByr
New Contributor III

Re: Keep a dimension name in a selection box

Hi,

Thank you for the reply, 

I don't know how but the problem solves by itself.

In any case, I keep your answer if the issue come back.

Best regards.

ajaykakkar93
Contributor III

Re: Keep a dimension name in a selection box

mark correct if you are satisfied.
Regards & Thanks,
Ajay Kakkar
ajaykakkar93@gmail.com