topic Setting variable value to a value retrieved from resident table? in QlikView

Setting variable value to a value retrieved from resident table?

Thu, 18 Feb 2010 19:46:55 GMT

Hello, is there a way to set a variable value directly to a value retrieved from a resident table, something like this:

SET myVariable = SUM(Quantity) RESIDENT myTable

Thank you,

Jose.

pdumas — Thu, 18 Feb 2010 21:57:45 GMT

Hello,

Let myVariable=sum(Quantity);

will assign to myVariable the result of fhe sum.

Qlikview don't care with which table the field has been loaded.

Pierre.

Fri, 19 Feb 2010 00:35:56 GMT

Thank you for replying,

Using the syntax LET myVariable = SUM(Quantity);

Im getting this message:

"Aggregation expressions not allowed in GROUP BY clause"

Thank you in advance,

Jose.

Anonymous — Fri, 19 Feb 2010 07:07:44 GMT

I ran into this too. This is what I did to get my statistic.

mydatasummed:
load sum(MyVariable) as MyVariableSum resident mydata ;

let x = peek('MyVariableSum',0,'mydatasummed');

See if that works for you.

pdumas — Fri, 19 Feb 2010 09:26:14 GMT

I can propose another syntax:

mydatasummed:

mapping

'mysum'

as mysum,

sum

(Quantity) as myquantity

resident

If you use the syntax proposed by Tim, do not forget to drop the table

Pierre.

myTable;

let

myvariable=applymap('mydatasummed','myquantity');load

Thu, 20 Oct 2011 21:39:31 GMT

This Works!