topic Re: Get Average from a table in QlikView

Get Average from a table

paulcalvet — Tue, 03 Dec 2013 20:25:38 GMT

Hi everyone,

I want to assign to a variable the value of a cell line of Average.

Exemple :

Dimension value1 value2

AAAAA 10 1

BBBBB 20 1

CCCCC 30 2

AVG 20 2

The second value is calculated and i want to retrieve it.

how can I get this value ?

thanks !!

Paul

Re: Get Average from a table

Anonymous — Tue, 03 Dec 2013 22:26:56 GMT

Paul,

You're calculating this average using an expression in the chart. That means, you have to use the same expression to define your variable. There are two options, depending on your needs:
1. You want this variable to be dynamic. That is, selections change - variable changes. In this case you have to define your variable in the Variables Overview as
=<expression>
2. You want to capture the value of the average at some moment, and it keeps the value until you decide to change it. In this case, create a button or a text box with action "Set Variable", with the Value
=<expression>

Hope it helps.

Regards,
Michael

Re: Get Average from a table

alexis — Tue, 03 Dec 2013 22:54:59 GMT

Hi Paul,

If I am understanding you correctly you want to store the calculated averages into variables.

If that is the case then the approach would be something like this:

Step 1:

- Create 2 variables,say vAvgValue1 and vAvgValue2

Step 2:

- in your code

TEMP:

Load num(avg(Value1) as Value1Average,

Load num(avg(Value2) as Value2Average

RESIDENT mytable;

LET vAvgValue1 = peek('Value1Average', 0,TEMP);

LET vAvgValue2 = peek('Value2Average', 0,TEMP);

DROP TABLE TEMP;

Hope this helps

regards

Alexis