Qlik Community

Qlik Sense App Development

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

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
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
ajaykakkar93
Valued Contributor

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

4 Replies
ajaykakkar93
Valued Contributor

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.

ajaykakkar93
Valued Contributor

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

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
Valued Contributor

Re: Keep a dimension name in a selection box

mark correct if you are satisfied.