Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
March 26 at 10am ET: See how Qlik drives growth and value in ISV segment - REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
PaoHL
Contributor III
Contributor III

Formula of Master item is displayed in app instead of Master item's name

I'm following along the video titled Create a Master Calculated Dimension. As per instructed by the video, I've created a new master dimension called "Month-Year", where the expression is  `=Month & '-' & Year`

When I edit the sheet and add the recently created master dimension to the sheet, it is added as a table column with the name '=Month & '-' & Year' instead of its actual name "Month-Year".

Is this a bug? In the video, the table has the right name.

PaoHL_0-1730904450786.png

But in my sheet, this is what I see:

PaoHL_1-1730904501454.png

 

 

Here I'm sharing the configuration of my master dimension. As you can see, the field is name appropriately named. 

PaoHL_2-1730904595182.png

 

Any insights are valuable! Thanks 😄

Labels (1)
2 Solutions

Accepted Solutions
Frank_S
Support
Support

In image PaoHL_2-1730904595182.png try placing the title you want to use in the "label expression" field.

 

Kind regards.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

PaoHL
Contributor III
Contributor III
Author

Just replying to add that I tried this using single quotation marks around the desired name and an equal sign before the whole string (='Month-Year') in the "Label expression" field as you suggested, and it worked.

View solution in original post

3 Replies
Frank_S
Support
Support

In image PaoHL_2-1730904595182.png try placing the title you want to use in the "label expression" field.

 

Kind regards.

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
PaoHL
Contributor III
Contributor III
Author

Hi Frank, 

Thank you for the suggestion. It seems that field is for something else, because it has a formula button:

Screenshot of Master Dimension configuration screen, where desired name for Master Dimension has been written in the "Label expression" fieldScreenshot of Master Dimension configuration screen, where desired name for Master Dimension has been written in the "Label expression" field

I tried it nonetheless, but this was the result:

Screenshot of a table visualization containing the Master Dimension "Month-Year" as one of its columns. The name has been changed to simply a dash"-"Screenshot of a table visualization containing the Master Dimension "Month-Year" as one of its columns. The name has been changed to simply a dash"-"

I tried using quotation marks around the string too, thinking that would work, but actually, the field gets highlighted red and it is not possible to change the configuration any more:

Screenshot of the Master Dimension configuration window, where the desired name has been written as a string surrounded by quotation marks in the field "Label expression".Screenshot of the Master Dimension configuration window, where the desired name has been written as a string surrounded by quotation marks in the field "Label expression".

I also tried adding an equal sign before the string in quotation marks, but that resulted in the field highlighted in red as well.

😕

PaoHL
Contributor III
Contributor III
Author

Just replying to add that I tried this using single quotation marks around the desired name and an equal sign before the whole string (='Month-Year') in the "Label expression" field as you suggested, and it worked.