Using Measures in measures

[heid_f]

Hey everyone,

is it in QlikSense possible to use a measure in another measure?

At example we have the first measure "Sales", the second measure "Costs" and want to create the third measure "profit" with "sales" - "costs".

In QlikView there was a possibility to use a measure in another measure using $(sales).

Does anyone know this works in QlikSense?

Thanks and Best Regards,

Fabian

[JuanGerardo]

Hi @heid_f, yes it works like in QlikView, so you can use:

Let profit = $(sales) - $(costs)

And in the last versions you can also use master measures into the Qlik Sense expressions or into other master measures.

JG

[rwunderlich]

You can reference Measures in expressions beginning with the Feb 2021 release.

-Rob

[Dalton_Ruer · Accepted solution]

As Rob mentioned above starting in Feb 2021 release you can reference master measures inside of others. If you are using a version earlier than that, you will want to establish variables that can be utilized as Juan referenced. 

[heid_f]

Great, thanks for the solution.
We will update to the Feb 2021 release.