topic Re: Qlik sense variable calculation before expression evaluation fails. in App Development

Qlik sense variable calculation before expression evaluation fails.

jjmartegarcia — Mon, 20 Dec 2021 21:38:40 GMT

Hello everyone,

I have the following issue:

I want to use the numerical value of a variable (as a constant) instead of the expression in a pivot table.

The expression for the variable in the variable editor is the following: =Sum({1<Jaar = P(), DateID={"TRANSDATE"}, [asset.htm_tramtype_description] ={"Avenio"},[asset.assettype]={"TRAM"}>}[meterreading.delta])

The pivot table has one dimension and looks like:

The expression for the measure in the pivot table :

$(vKM_Avenio)
/
count(distinct {<[workorder.worktype]={"STO"}>} workorder.wonum)

As you can see in the picture above, in the pivot chart only null is displayed for the measure. The expression "count(distinct {<[workorder.worktype]={"STO"}>} workorder.wonum)" has an association with the dimension so this is not the cause. The expression underneath the variable vKM_Avenio does not have an association with the dimension, but since the variable has been defined with a preceeding "=" sign, I expected that this would work.

What am I doing wrong here? Or is this just not possible with Qlik Sense?

Help is much appreciated!

Kind Regards,

Junior

Re: Qlik sense variable calculation before expression evaluation fails.

agigliotti — Thu, 04 Jul 2019 13:48:19 GMT

it seems the variable "vKM_Avenio" value is correct (18871758,50).
let's try using "count(distinct {<[workorder.worktype]={"STO"}>} workorder.wonum)" as expression in your pivot table to see what you get.

Re: Qlik sense variable calculation before expression evaluation fails.

jjmartegarcia — Thu, 04 Jul 2019 13:56:08 GMT

Hi Agigliotti,

This is what I get:

Kind Regards,

Junior

Re: Qlik sense variable calculation before expression evaluation fails.

agigliotti — Thu, 04 Jul 2019 15:14:46 GMT

what about using the below expression:

vKM_Avenio
/
count(distinct {<[workorder.worktype]={"STO"}>} workorder.wonum)

Re: Qlik sense variable calculation before expression evaluation fails.

jjmartegarcia — Thu, 04 Jul 2019 21:18:36 GMT

Thanks Agigliotti!

This does the job.

I'm curious to know where you got this information from. This is what Qlik help explains.

Kind Regards,

Junior