Qlik Community

App Development

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

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
philip_radovich
Contributor III
Contributor III

Hide expression of measure

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

1 Solution

Accepted Solutions
rubenmarin

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?

View solution in original post

6 Replies
timpoismans
Specialist
Specialist

Where does it show the expression when hovering over it?

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

rubenmarin

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?

View solution in original post

philip_radovich
Contributor III
Contributor III
Author

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

Thanks,

Phil Screen Shot 2018-09-27 at 10.49.37 AM.png

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:

Captura.PNG

timpoismans
Specialist
Specialist

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
Specialist II
Specialist II

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.