topic Re: help with variable in QlikView

help with variable

Thu, 27 Oct 2011 22:05:13 GMT

Hello

I have the following and it works fine, just send me a variable to zero, I could support if well done telling my variable using RANGESUM

Temp:

Load sum(DATA) as totSales
Resident VentaOriginal
Where AGRUPADOR='01_VENTAS';

Let vTotSales = peek('totSales',0,'Temp'); --------->This variable is well,
Let vSales = Rangesum(totSales); ---------> This variable just send zero.

Help me

Fri, 28 Oct 2011 04:46:08 GMT

RangeSum cannot be applied this way in script. What is that you want to have in vSales variable?

Kiran.

Fri, 28 Oct 2011 14:21:21 GMT

I want the sum of DATA, how could it get?

Fri, 28 Oct 2011 14:26:20 GMT

I think thats what you are getting in vTotSales. How is this sum different from vTotSales?

Kiran.

Fri, 28 Oct 2011 17:04:38 GMT

ok thanks, and you understood what I did was create a temporary table and create what I needed there.

Another thing as I do in my field acumudalo DATA. I put the following

Rangesum (peek ("ACUMULADO"), DATA) as ACUMULADO

but the moment in a pivot table compare this with data and accumulated option does not give me the same result.

Fri, 28 Oct 2011 18:11:02 GMT

For accumulation I use numsum function. Please refer help on this: Interrecord functions -> Peek Function last example. Hope it helps you.

Kiran.