topic Re: Problem with variable evaluation in App Development

Problem with variable evaluation

mikegrattan — Wed, 05 Jul 2017 16:39:54 GMT

I have variables set up for the following calculations:

I am displaying these variables via Master Measures in a straight table in Qlik Sense 3.1

Variable Name: vBPHYr2

Definition:

Sum({$<Year = {"$(=max({1} Year)-1)"}>} HoursWorked) /

Sum({$<RecordType={'RECEIPT'},Year = {"$(=max({1} Year)-1)"}>} UnitsReceived)

This gets me a "Boxes Per Hour" value that evaluates correctly. For example, I get a value of 5.83 for the selected Product.

Variable Name: vBPHYr3

Definition:

Sum({$<Year = {"$(=max({1} Year)-2)"}>} HoursWorked) /

Sum({$<RecordType={'RECEIPT'},Year = {"$(=max({1} Year)-2)"}>} UnitsReceived)

Evaluates correctly as 5.10 for the specified year and selected Product.

Variable Name: vBPHYr2_Var

Definition: $(vBPHYr3) - $(vBPHYr2)

Evaluates correctly as 0.72

Now I want to take vBPHYr2_Var and divide by vBPHYr3 to get the variance as a percentage.

Variable Name: vBPHYr2_Var%

Definition: $(vBPHYr2_Var) / $(vBPHYr3)

This evaluates to 0

Please advise.

Thank you.

Re: Problem with variable evaluation

sunny_talwar — Wed, 05 Jul 2017 16:44:38 GMT

0.72/5.10 seems like a small number, do you have the decimals set to 0 may be? Try increasing the number of decimals to see value?

Re: Problem with variable evaluation

mikegrattan — Wed, 05 Jul 2017 17:39:34 GMT

I tried setting decimal to four places and still getting zero.

Re: Problem with variable evaluation

sunny_talwar — Wed, 05 Jul 2017 17:41:15 GMT

Give this a shot

($(vBPHYr2_Var))/$(vBPHYr3)

Re: Problem with variable evaluation

mikegrattan — Wed, 05 Jul 2017 17:43:33 GMT

Still zero.

Re: Problem with variable evaluation

sunny_talwar — Wed, 05 Jul 2017 17:48:33 GMT

Would you be able to share a sample?

Re: Problem with variable evaluation

mikegrattan — Wed, 05 Jul 2017 17:58:07 GMT

Here you go. Note: The sheet called Boxes Per Hour Detail - 3 Years has the straight table I'm referencing for testing.

Re: Problem with variable evaluation

sunny_talwar — Wed, 05 Jul 2017 18:40:17 GMT

This worked

($(vBPHYr2_Var))/($(vBPHYr3))

Re: Problem with variable evaluation

mikegrattan — Wed, 05 Jul 2017 19:19:49 GMT

Perfect; thank you very much.