Hide expression of measure

[philip_radovich]

Hi,

I am looking to see if there is any way to hide an expression from showing in a hover over in QlkiSense. My expression is: sum({<MonthYr={">$(=Date(AddMonths(Date(MonthStart(Today()),'MMM-YYYY') , -12), 'MMM-YYYY'))<=$(=Date(MonthStart(Today()),'MMM-YYYY'))"}>}CareTime)/Count({<MonthYr={">$(=Date(AddMonths(Date(MonthStart(Today()),'MMM-YYYY') , -12), 'MMM-YYYY'))<=$(=Date(MonthStart(Today()),'MMM-YYYY'))"}>}Distinct InjurySK).  I am trying to figure out if it's possible to force it to show what the label is set as or hide the expression entirely.

Thanks,

Philip Radovich

[timpoismans]

Where does it show the expression when hovering over it?

In a table, graph,... or somewhere else?

[rubenmarin · Accepted solution]

Hi Philip, usually there is a text box to set the label of expression, wich is what user seens instead of the expresion. In wich object/charttype are you not allowed to set the label?

[philip_radovich]

It's showing in the graph. Please see the attached screenshot.

Thanks,

Phil

[rubenmarin]

Line chart has a text box to set the label, expanding the expression you should see the text box, the chart will show that text:

[timpoismans]

Where you entered the expression, there should be a textbox under as "Label"

If you give the expression a name there, it shouldn't put the whole measure in the pop-up anymore.

[undergrinder]

Hi Philip,

try to use label for expression, as others mentioned.

You can master item as well, so you can use this expression as a field. It is very handy when the expression is used by multiple object.

+1 for master items: You can do that with dimensions as well.

Example:

=if(date>'2018-01-01',date,null())

If you use this in a table and filter on it, in the filter ribbon you see the expression instead of label.

If we make a master item based on the expression, the label will appear in the filter ribbon.

G.