Discussion board where members can get started with Qlik Sense.
Hi there, I'm new in qlik sense and i'm trying to build an app that shows a daily index scores. index score formula is (currentScore/PreviousScore)*100. but my problem is i don't know how to get the previous data inside the measure. please help
here's my sample data
In the script you can use the previous() function:
Score/Previous(Score)*100 as IndexScore
In charts you can use the Above function: Num(Score/Above(Score),'0.00%')