topic Re: Hide expression of measure in App Development

Hide expression of measure

philip_radovich — Thu, 27 Sep 2018 14:31:12 GMT

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

Re: Hide expression of measure

timpoismans — Thu, 27 Sep 2018 14:33:05 GMT

Where does it show the expression when hovering over it?

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

Re: Hide expression of measure

rubenmarin — Thu, 27 Sep 2018 14:39:13 GMT

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?

Re: Hide expression of measure

philip_radovich — Thu, 27 Sep 2018 14:51:33 GMT

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

Thanks,

Phil

Re: Hide expression of measure

rubenmarin — Thu, 27 Sep 2018 14:57:28 GMT

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:

Re: Hide expression of measure

timpoismans — Fri, 28 Sep 2018 06:05:37 GMT

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.

Re: Hide expression of measure

undergrinder — Fri, 28 Sep 2018 08:05:14 GMT

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.