Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
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