topic Re: Accumulation in script help in QlikView

Accumulation in script help

Anonymous — Tue, 25 Apr 2017 17:51:55 GMT

how to get count of rows in load script

Date ID

24/04/2017 11

25/04/2017 10

26/04/2017 12

27/04/2017 37

want to know count of rows if select 26/04/2017 - count should be 3, if 27/04/2017 --- count should be 4

Re: Accumulation in script help

sunny_talwar — Tue, 25 Apr 2017 17:53:38 GMT

You mean if 27/04/2017 is selected count should be 4.... may be use RowNo() to count

LOAD Date,

RowNo() as Count

Resident ...

Order By Date Asc;

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 17:54:14 GMT

Let var = NoofRows('YourTable');

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 18:03:37 GMT

No Sunny its not working

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 18:04:42 GMT

could you explain again what you need...

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 18:08:36 GMT

I want an extra field in load script where it should tell me the count of rows, if I select 26th Date it should show the count as 3 and if it is 27th count as 4

Re: Accumulation in script help

sunny_talwar — Tue, 25 Apr 2017 18:13:43 GMT

So what issue did you run into by using RowNo()?

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 18:16:55 GMT

Pls find attached app Sunny, whenever I select dates the count is shown as 1

Re: Accumulation in script help

sunny_talwar — Tue, 25 Apr 2017 18:18:39 GMT

Try Max(Count1) as your expression

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 18:27:30 GMT

Thnx Sunny, my bad, i haven't posted the my entire question correctly, I want 1 step back accumulation in the script as a new field

Re: Accumulation in script help

sunny_talwar — Tue, 25 Apr 2017 18:29:30 GMT

I want 1 step back accumulation in the script as a new field

Can you explain this with an example? I am not sure I understand this

Re: Accumulation in script help

Anonymous — Tue, 25 Apr 2017 18:34:53 GMT

In the above case, if I select 24th Date Sum of ID should be 11,

if I select 25th Date Sum of ID should be 10 + 11 -->21

if I select 26th Date Sum of ID should be 12 +10 - > 22

Re: Accumulation in script help

sunny_talwar — Tue, 25 Apr 2017 18:50:46 GMT

Try this

LOAD * INLINE [

Date, ID

24/04/2017, 11

25/04/2017, 10

26/04/2017, 12

27/04/2017, 37

];

Load Date,

ID,

RowNo() as Count1,

RangeSum(Peek('CumID'), ID) as CumID

Resident A

Order By Date asc;

Drop table A;