Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

henry_tran
New Contributor II

Strange Bug Year to Year Comparion in Pivot table

Hi all,

I have a Pivot table with different amounts. These amounts should be compared to the the same time one year before and show the %-difference.

I have one strange problem. For the year 2017 it shows me the wrong %-difference. Everything else is correct (i.e. comparing 2016 to 2015). But 2017 to 2016 shows me wrong numbers.

Capture.JPG

currently my logic is looking like this

If(Sum({< Flag = {'2017'}>}FF_FF_FLIGHT_SUM) > 0,

Sum({< Flag = {'2017'}>}FF_FF_FLIGHT_SUM)

/

Sum({< Flag = {'2016'}>}FF_FF_FLIGHT_SUM) - 1)

Attached is a sample.

Does anybody know a solution for this strange bug?