Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for
Did you mean:
Creator III

## Problem with variable evaluation

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

Thank you.

1 Solution

Accepted Solutions
MVP

This worked

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

8 Replies
MVP

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?

Creator III
Author

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

MVP

Give this a shot

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

Creator III
Author

Still zero.

MVP

Would you be able to share a sample?

Creator III
Author

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

MVP

This worked

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

Creator III
Author

Perfect; thank you very much.