Script : how to create table of accumulations

[chris987]

hi all,

I'm new in Qlikview.

I’d to like create a Table of accumulations with data from a QVD.

Original Data  :

Item	Customer N°	Price	Qty	Date	Year	week	Month
123456	C131345	15$	8	2011/09/01	2011	201135	09
321456	C131345	12$	2	2011/09/13	2011	201137	09

I’d like the Table of accumulations to look like this :

Customer N°		Year	Month	Week	Activity
C131345		2011	09	201135	1
C131345		2011	09	201136	0
C131345		2011	09	201137	1

etc.

if sales <> 0 then Activity = 1 else Activity = 0

Maybe, another solution exists.

Is it possible in script ?

Thank for your help

Chris.

[#2]

Load

[Customer N°],
Year,

Month,

Week,

if(sales <> 0,1,0) as  Activity

From [document path here ] (qvd);

Assuming there is a field called Sales. Other wise just write the condition in if statement

If there is no sales field try Quantity>0 condition

[#3]

Hi,

u can do somthing like this.

i hope this help

Stefano

[chris987]

Hi,

Stefano your idea is not possible for me, i have more 3 millions lines in my database, and the loading is too long.

I have clear my project, and find another way.

thanks for your help.