topic Re: Variable in set analysis modifier not working in App Development

Variable in set analysis modifier not working

mehek9074 — Wed, 06 Nov 2019 05:38:53 GMT

Hello All
Need Urgent help regarding this

I am having a variable eg. vVar1= vVarA/vVarB
And I am using this variable in a set analysis modifier like this:
Count(distinct {<Field_A= {"=$(vVar1) =1"}>} Field_A)
But however it's not working.
Appreciate if anybody can help on this.

Re: Variable in set analysis modifier not working

tresB — Wed, 06 Nov 2019 06:33:52 GMT

What are you trying to compare the field Field_A with? Could you explain the logic/filter for Field_A? It's bit confusing when you compare a variable with 1.

Re: Variable in set analysis modifier not working

mehek9074 — Wed, 06 Nov 2019 06:56:32 GMT

Actually I have stored one kpi formula in a variable(vVar1).

Whenever this variable formula is evaluated, it gives some values between 1to 20.

so I want to get the count of only those values of fieldA where that vVar1 value is 1.
i.e count of fieldA wherever vVar1= 1

Re: Variable in set analysis modifier not working

tresB — Wed, 06 Nov 2019 07:03:39 GMT

This condition looks a vague one to me. Could you explain with an example? Could you share the two variables definitions ?

Re: Variable in set analysis modifier not working

mehek9074 — Wed, 06 Nov 2019 09:18:08 GMT

I have uploaded the dummy data file and sample qvf.

I have created a variable vKPIOverallScore in the script and
I am trying to use the variable in set analysis modifier in a KPI measure on UI.

But its not working.
Moreover, I tried creating a flag with if condition in the script by using that variable but no luck.

Re: Variable in set analysis modifier not working

tresB — Wed, 06 Nov 2019 09:32:59 GMT

You have to make a change in quotes in variable definition to avoid conflict. Try like:

Let vKPIOverallScore='round((Avg({$'&'<Year = {[$'&'(=max(Year))]}>}Scores)) ,0.01)';

I used '['']' (in red) in place of single quotes

Re: Variable in set analysis modifier not working

mehek9074 — Wed, 06 Nov 2019 10:12:05 GMT

Is it working for you ?
because I tried , it is not working for me.

Re: Variable in set analysis modifier not working

tresB — Wed, 06 Nov 2019 10:18:42 GMT

I am getting 9 as output.