Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
johnhorneramllp
Partner - Contributor III
Partner - Contributor III

Accumulating Data in the Script

I would like to accumulate Metric1 in Table 1 (attached) in the Load Script across the Period field for each Release. However upon doing so i would also like to set the first Period for each Release to start at 1 and then increment by 1. So for Release 2009, Period 2009-02 would become 1, Period 2009-03 would become 2 and so on. For Release 2010 Period 2010-03 would become 1, Period 2010-04 would become 2 and so on.

Can anybody suggest a way of doing this in the load script please. I have a larger / wider requirement than this so i cannot simply use the full accumulation within the Chart so this must be done in the creation of the dataset.

Regards

JH

0 Replies