topic Re: How to call "Master Item" into a formula? in App Development

How to call "Master Item" into a formula?

Milaf — Tue, 21 Nov 2023 07:04:06 GMT

Hello, I developed the formula below to calculate according to the period selection on the frontend. Is there any way to call Master Item to this formula?

=if(GetFieldSelections([Period])='Daily',avg({<Today_T= {'$(vYesterday)'}>} [calculated_masteritem]),
if(GetFieldSelections([Period])='Weekly',avg({<Today_T= {'$(vPreviousWeek)'}>} [calculated_masteritem]),
if(GetFieldSelections([Period])='Monthly', avg({< Monthly = {'$(vMonthly)'}>} [calculated_masteritem])
)))

The syntax seems correct but result 0 returning 😞

Re: How to call "Master Item" into a formula?

Aasir — Tue, 21 Nov 2023 07:26:05 GMT

Your formula looks correct.
Ensure that the Master Item [calculated_masteritem] is working as expected independently. You can test it by directly using this Master Item in a chart or table to verify that it produces the desired values.
Double-check the values of your variables (vYesterday, vPreviousWeek, vMonthly) to make sure they are being set correctly and are valid dates.
You can add temporary variables or text boxes in your Qlik Sense app to display the values of your variables and selections. This can help you debug and understand what values are being used in your calculations.

Below is a modified version of your formula with additional labels for each condition, which might help you identify the issue:

=if(GetFieldSelections([Period])='Daily',
avg({<Today_T= {'$(vYesterday)'}>} [calculated_masteritem]),
if(GetFieldSelections([Period])='Weekly',
avg({<Today_T= {'$(vPreviousWeek)'}>} [calculated_masteritem]),
if(GetFieldSelections([Period])='Monthly',
avg({< Monthly = {'$(vMonthly)'}>} [calculated_masteritem]),
'Invalid Period Selection'
)))

Re: How to call "Master Item" into a formula?

Milaf — Wed, 22 Nov 2023 08:28:43 GMT

@Aasir Thank you for the answer, but the variables and calculations work separately. It works when I add a field from the data instead of the master item. Master Item also brings the correct result, but it does not work when I call it to the formula.

I changed the domain names when I added it here for clarity, the screenshot shows the original version.

Re: How to call "Master Item" into a formula?

Aasir — Wed, 22 Nov 2023 15:37:48 GMT

Have to dive deep to check, try square brackets

Re: How to call "Master Item" into a formula?

rwunderlich — Wed, 22 Nov 2023 16:03:09 GMT

You cannot use a master item within an aggregation function. In your post, Sum(calculation_measure) is not allowed.

https://help.qlik.com/en-US/sense/August2023/Subsystems/Hub/Content/Sense_Hub/Expressions/references-fields-measures-variables.htm

-Rob