Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello all...
I am new to Qlik. My issue is carry forward values, but i want in date level. Can we hold the first generate score (03-12-18) and second generate score (07-12-18) Dates. Based on these two dates can we get the new score ? Plz see the image below.
Thanks and Regards..
You can find the solution in this document: https://community.qlik.com/t5/QlikView-Documents/Generating-Missing-Data-In-QlikView/ta-p/1491394
And yes, this works in Qlik Sense too.
Use below syntax to create new field (if Your Score is =0 or Score isnull then your Score will be carry forwarded).
LOAD
"Date",
Score,
if(len(trim(Score))=0 or Score=0,Peek(New_score),Score) as New_score
resident DATA;
Thank You for your reply...
Thank you Ashok
If some dates are missing means how can we calculate.... i.e for example : 3/12/18--------- 45, 7/12/18------- 75.
how can we get new score for the dates 4/12/18 to 6/12/18 as 45.