Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

stats101
New Contributor

Percentage difference with previous record in Pivot table

Hi,

I'm wanting to calculate the year on year percentage difference in a pivot table (structure below). I suspect I need to use a set analysis expression? Any help is appreciated.

Capture.PNG

Thanks

1 Solution

Accepted Solutions

Re: Percentage difference with previous record in Pivot table

Try Above(Accident_Index)

Edit: Previous is a script only function and cannot be used in the front end of the application. Check out the link: http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/InterRecordFunction...

Best,

Sunny

1 Reply

Re: Percentage difference with previous record in Pivot table

Try Above(Accident_Index)

Edit: Previous is a script only function and cannot be used in the front end of the application. Check out the link: http://help.qlik.com/sense/2.0/en-US/online/#../Subsystems/Hub/Content/Scripting/InterRecordFunction...

Best,

Sunny

Community Browser