different value in pivot table and listbox

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi here is my problem, I use this formula in both listbox and pivot table:

24*(SUM({$<[Is Budget]={'0'},DATEPERIOD={'>=$(=YEARSTART(MAX(DATEPERIOD)))<=$(=MAX(DATEPERIOD))'},Year,Month,Quarter>}Revenue)
+SUM({$<[Is Budget]={'0'},DATEPERIOD={'>=$(=YEARSTART(MAX(DATEPERIOD)))<=$(=MAX(DATEPERIOD))'},Year,Month,Quarter>}[Income])
-SUM({$<[Is Budget]={'0'},DATEPERIOD={'>=$(=YEARSTART(MAX(DATEPERIOD)))<=$(=MAX(DATEPERIOD))'},Year,Month,Quarter>}[Expense])
)
/
(SUM({$<[Is Budget]={'0'},DATEPERIOD={'>=$(=date(YearStart(MAX(DATEPERIOD))-31))<=$(=date(YearStart(MAX(DATEPERIOD))-1))'},Year,Month,Quarter>}[OS Net Investment])
+SUM({$<[Is Budget]={'0'},DATEPERIOD={'>=$(=YEARSTART(MAX(DATEPERIOD)))<=$(=MAX(DATEPERIOD))'},Year,Month,Quarter>}[OS Net Investment]))

but it give me 2 different results of value (image attached)

the blue one is from pivot table

I wish the result in pivot table will be the same as the result in list box, which is the correct one.

can anyone help please

topic different value in pivot table and listbox in QlikView

different value in pivot table and listbox