Discussion Board for collaboration on QlikView Scripting.
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 :
if sales <> 0 then Activity = 1 else Activity = 0
Maybe, another solution exists.
Is it possible in script ?
Thank for your help
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
u can do somthing like this.
i hope this help
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.