Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
kavicsgym
Contributor

RangeAvg with 2 variables not calculates

                        

Hi, could anyone pls. help me out, I found a workaround but this would be nicer:

RangeAvg(20, 40)  is the definition or my variable in Qlik sense, it works

But with a nested expression it does not work, can anyone suggest pls why?

RangeAvg    

  $(ePDCA_WSAuslief_Pkd_Total(01)), $(ePDCA_WSAuslief_Pkd_Total(02))

     )

Those 2 expressions are complicated enough... how could I pass their value to RangeAvg?????

Thanks a lot! Enikö

Tags (2)
12 Replies

Re: RangeAvg with 2 variables not calculates

I don't see a reason why this shouldn't work with complicated expression.Where are you trying this? In a chart or text box object?

kavicsgym
Contributor

Re: RangeAvg with 2 variables not calculates

Hi, thanks for your response.

I try to show the result in both text object:  'Avg.Pkd/Year - Delivery: ' & num($(ePDCA_Avg), '# ##0,00')

and also in a Line chart (with YM as Dim) as a Reference Line: =$(ePDCA_Avg)

Those 2 expressions have Total qualifier in them, to disregard the Line chart's YM dim.

Enikö

Employee
Employee

Re: RangeAvg with 2 variables not calculates

Which values $(ePDCA_WSAuslief_Pkd_Total(01)) and $(ePDCA_WSAuslief_Pkd_Total(02)) return?

kavicsgym
Contributor

Re: RangeAvg with 2 variables not calculates

They give the result of this:

RangeSum(

sum(TOTAL{$<Version={'$(=Only(Version))'}, Year={'$(vYear)'}, Month#={"$1"}, YM= >} Measure1 + Mesure2)

  /

   (sum(TOTAL{$<Version={'$(=Only(Version))'}, OrigVersion={'ACTUAL'}, Year={'$(vYear)'}, Month#={"$1"}, YM= >} Measure3) + sum(TOTAL{$<Version={'$(=Only(Version))'}, Year={'$(vYear)'}, Month#={"$1"}, YM= >} Measure4))

01 for January, 02 for February

Values, like: 6,7 .... 8,9.... 10,5   ...sg in this range.

They return OK values in a text box.

E

Employee
Employee

Re: RangeAvg with 2 variables not calculates

They return single values?

So your rangesum would be rangesum(val1, val2) or they return a list of values?

kavicsgym
Contributor

Re: RangeAvg with 2 variables not calculates

Each of the 2 above expressions return 1-1 single value (e.g. 7,5 and 8,5) - and I want their avarage.

(((Rangesum is used only for this: if the denominator is zero, (sum of Measure 3+4) the Expressions returns null(). Rangesum turns it into a 0. But lets forget the rangesum, it is not relevant for my problem.)))

Thanks for looking into it, by the way

Employee
Employee

Re: RangeAvg with 2 variables not calculates

Do they return values with "," ?

Partner
Partner

Re: RangeAvg with 2 variables not calculates

Hi,

Just a hunch, forgive me if am way off.

Instead of

sum(TOTAL{$<Version={'$(=Only(Version))'}, Year={'$(vYear)'}, Month#={"$1"}, YM= >} Measure1 + Mesure2)

(

sum(TOTAL{$<Version={'$(=Only(Version))'}, Year={'$(vYear)'}, Month#={"$1"}, YM= >} Measure1)

+

sum(TOTAL{$<Version={'$(=Only(Version))'}, Year={'$(vYear)'}, Month#={"$1"}, YM= >} Mesure2)

)

What if one of the measures has a Null value and is resulting in the Measure1+Measure2 becoming Null.

kavicsgym
Contributor

Re: RangeAvg with 2 variables not calculates

Hi, sorry I was hold up in a project...

Yes, they do.... so you probably refer to the fact that values have a comma in them, and at the same time tthe separator is a comma....

RangeSum(30,5 , 40,5) does not work but RangeSum('30,5' , '40,5') does calculate.

I just have to figure out who to pass my eExpressions 🙂