topic Re: accumulation in script - still struggling in QlikView

accumulation in script - still struggling

Fri, 17 Aug 2012 18:23:56 GMT

I am attaching the sample qvw file.

I am not getting the counts for LoginsOnThisHost field.

Could somebody please help!!!

Re: accumulation in script - still struggling

Anonymous — Fri, 17 Aug 2012 19:05:12 GMT

change the 3rd expression as count(LoginsOnThisHos)

Re: accumulation in script - still struggling

bgerchikov — Fri, 17 Aug 2012 19:06:19 GMT

Hi,

your expression shows field value only. Try to use something like

count(LoginsOnThisHost) or Sum(LoginsOnThisHost)

Hope it will help.

Re: accumulation in script - still struggling

Fri, 17 Aug 2012 19:10:16 GMT

Thanks Boris and Srikant.

Making it count or sum just makes the point clearer - i get zeros.

Indeed, i want the field value of loginsonthishost because the accumulation is done in the script using a set of previous functions and ordering the resident load.

Re: accumulation in script - still struggling

Fri, 17 Aug 2012 19:37:10 GMT

Here is a simpler code -

Load1:
load * inline
[data1, data2
a,1
b,1
c,-1
d,1
e,-1
b,1
b,-1
a,-1
a,2
a,3
a,4
a,5];

DingoLog:
LOAD *,
if ( Previous('data1')=data1,Previous('data3')+data2,data2) as data3
Resident Load1 Order by data1;

Why is this not giving me counts for data3?

Re: accumulation in script - still struggling

bgerchikov — Fri, 17 Aug 2012 20:03:42 GMT

Try to clear selection - you'll see numbers

Re: accumulation in script - still struggling

Fri, 17 Aug 2012 20:37:06 GMT

After playing with it for some time, here is what seems to be working

Load1:
load * inline
[data1, data2
a,1
b,1
c,-1
d,1
e,-1
b,1
b,-1
a,-1
a,2
a,3
a,4
a,5];

DingoLog:

LOAD *,
if ( Peek(data1)=data1,Peek(data3)+data2,data2) as data3
Resident Load1 Order by data1,data2;

DROP Table Load1;

NOTE: There is some strange difference between peek and previous.