Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Compute index score inside measure

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

DayScoreBranch
Sun80BR01
Mon95BR02
Tue70BR01
Wed85BR02
Thu95BR02
Fri85BR01
Sat80BR01
Sun75BR02
Mon85BR02
Tue85BR01
Wed70BR02
Thu90BR01
Fri75BR02
Sat95BR01
Tags (1)
1 Reply

Re: Compute index score inside measure

In the script you can use the previous() function:

LOAD

     Day,

     Score,

     Score/Previous(Score)*100 as IndexScore

     Branch

FROM

     ...;

In charts you can use the Above function: Num(Score/Above(Score),'0.00%')


talk is cheap, supply exceeds demand
Community Browser