Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
I am new new qlik so please help out. Every week i will be loading 2 fields i.e Name and Score. What i want is to find the difference in score from current week to the one in past week. How should i write a script to back up last week and import current week and then find the difference between them?
If you follow my first step storing daily data into qvds then you can do the following.
//LOAD ALL YOUR QVDS
DATA:
LOAD * FROM data_$(vDate).qvd (qvd)
FINALDATA:
NOCONCATENATE LOAD Name, [Score] - if(peek('Name')=Name, peek('Score') ,0)as ScoreChange, [Date] , [Score] Resident DATA order by Name ,Date asc; Drop table DATA;