Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Hi,
u can do somthing like this.
i hope this help
Stefano
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.