topic Re: Get Average Between Dimensions in QlikView

Get Average Between Dimensions

lain_ — Mon, 06 Jul 2020 18:27:46 GMT

With the tables I have in the qvw file below, one is a table of Var1 and some values calculated from an expression, the other is a table of Var2 and some values calculated from an expression. How do I take the average of these values, so that Var1 has an associated average and Var2 has an associated average. The goal is to then graph this. I attached an excel file of what I want to avoid confusion.

Re: Get Average Between Dimensions

Taoufiq_Zarra — Mon, 06 Jul 2020 21:15:41 GMT

Maye be qvw attached file ?

Re: Get Average Between Dimensions

lain_ — Mon, 06 Jul 2020 21:20:55 GMT

Thank you so much. To expand on this. How would I go about adding a listbox to select the Var1, Var2. Let's say I have Var1, Var2, Var3, Var4 and I want to be able to select some of these to do the calculations.

Re: Get Average Between Dimensions

Taoufiq_Zarra — Mon, 06 Jul 2020 21:52:39 GMT

@lain_

in this case I suggest you change ValueList to island table:

attached qvw file

IslanTable: LOAD * INLINE [ Var,Measure Var1,Avg(total aggr(sum(total <Var1> value1) / sum(total <Var1> value2),Var1)) Var2,Avg(total aggr(sum(total <Var2> value1) / sum(total <Var2> value2) ,Var2)) ];

Re: Get Average Between Dimensions

lain_ — Mon, 06 Jul 2020 22:39:49 GMT

Thank you! I ended up needing to use a variable so I couldn't implement what you did with the load script, so I expanded on your first solution by replacing the value list with the listbox and adding more Var(s) in the match function. I'll accept your first solution to this since it directly solves my original question in case anyone else needs it.