Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

antoniotiman
Honored Contributor III

Re: How to calculate sum of last two months in script

Table loaded already sorted.

However, in my script Order By of large table (> 30M rows) lasts 10/15 minutes.

tunguyen
New Contributor III

Re: How to calculate sum of last two months in script

Dear Antonio,

Thank you so much.

And kindly need your help on my problem in case having 1 more dimension.

Data:

Load * Inline [

date, sales, outlet

1/1/2017, 1, a

2/1/2017, 1, a

4/1/2017, 0, a

5/1/2017, 0, a

7/1/2017, 1, a

9/1/2017, 1, a

10/1/2017, 1, a

1/1/2017, 0, b

2/1/2017, 1, b

3/1/2017, 1, b

4/1/2017, 1, b

5/1/2017, 0, b

6/1/2017, 0, b

3/1/2017, 0, c

4/1/2017, 1, c

5/1/2017, 1, c

6/1/2017, 0, c

7/1/2017, 0, c

];

Highlighted
antoniotiman
Honored Contributor III

Re: How to calculate sum of last two months in script

I don't understabd Your request,

Which is Your expected result ?

tunguyen
New Contributor III

Re: How to calculate sum of last two months in script

Thank you. I found solution, I run inline for every current date.

Thank you so much.