Discussion board where members can get started with Qlik Sense.
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_scoreresident 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.