Create custom dimensions on the fly that display measure values

You can create custom dimensions with measure expressions in them.

The trick for this to work is to use the Aggr() function, some times combined with the Only() function.


Comments

Post a Comment

Popular posts from this blog

Have extra tooltips in Qlik Sense chart natively.

Have extra tooltips in Qlik Sense chart natively. Here is a neat trick for creating additional mouseover tooltips in a chart with measures you do not want to include in your chart. Create a new measure, give it a descriptive name The measure function should be formatted like this: Text(<Measure expression>) Where <Measure expression> is for example Sum([Employees]) The next step is to choose the formatting type to Measure Expression. We now have a measure that is not understandable for the vizualiser but that is shown in the tooltip.
Read more