Department wise future data using loops in qlikview

[#1]

HI I have scenario,

I have data like below

Date,          Department,    salesAmount

2012/01/01    Retail                54688

2012/01/01      sales                568489

.

.

.

.

.

2016/06/01    agriculturl              54646476

So here Number of departments are around 20 and for this i need add future values(prediction) for

onemonth /one department(example 2017 12 monthes*20 deparments)  around 240 records

In qlikview is there any logic using loops?

Please do the needful

Thanks

Thiru

[#2]

HI Kushal,

Any update for the below code?

Thiru