Qlik Community

Qlik Sense App Development

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

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
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

View solution in original post

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

View solution in original post

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.

Highlighted
ajaykakkar93
Valued Contributor

Re: Keep a dimension name in a selection box

mark correct if you are satisfied.