topic Yearly Incentive Calculation in Data model in QlikView

Yearly Incentive Calculation in Data model

tahsin12 — Sat, 16 Nov 2024 18:03:16 GMT

Hello there,

I'm new to qlikview development. I need help regarding a requirement. I give the requirements given below.Please help.

its a sales table

Year	Month	Volume
2020	1	10
2020	2	20
2020	3	30
2020	4	40
2020	5	50
2020	6	60
2020	7	70
2020	8	80
2020	9	90
2020	10	100
2020	11	110
2020	12	120

now my required result for this table will be-

Year	Month	Volume	Incentive
2020	1	10	10
2020	2	20	30
2020	3	30	60
2020	4	40	100
2020	5	50	150
2020	6	60	210
2020	7	70	280
2020	8	80	360
2020	9	90	450
2020	10	100	550
2020	11	110	660
2020	12	120	780

the incentive field is the required result. The full calculation should be in qlikview script. I mean it's a back end calculation. Yearly cumulative calculation in qlikview script. Please help me out from this.

Regards

Tahsin12

@hic @johnw

Re: Yearly Incentive Calculation in Data model

Kushal_Chawda — Sun, 27 Sep 2020 12:44:26 GMT

@tahsin12 try below

Data: LOAD Year, Month, Volume FROM Source; Final: NoConcatenate LOAD *, if(Year<>Previous(Year),Volume,rangesum(Peek(Incentive),Volume)) as Incentive Resident Data Order by Year,Month; DROP Table Data;

Re: Yearly Incentive Calculation in Data model

tahsin12 — Thu, 01 Oct 2020 04:55:53 GMT

Thanks a lot @Kushal_Chawda it just perfectly worked.😊😊