topic Re: Script : how to create table of accumulations in QlikView

Script : how to create table of accumulations

chris987 — Tue, 20 Sep 2011 14:26:09 GMT

hi all,

I'm new in Qlikview.

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

Original Data :

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.

Tue, 20 Sep 2011 14:35:29 GMT

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

Tue, 20 Sep 2011 15:35:40 GMT

Hi,

u can do somthing like this.

i hope this help

Stefano

chris987 — Thu, 22 Sep 2011 15:17:31 GMT

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.