Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
leomathew
Contributor

Calculated columns using previous values?

Hi,

i have an input table like this.

   

DateCategoryCountOffsetTotal
Q4 2015D9
Q1 2016A9
Q1 2016B3
Q1 2016C8
Q1 2016D7
Q2 2016A7
Q2 2016B5
Q2 2016C2
Q2 2016D7

i need to calculate the columns Offset and total. the logic for which are as follows

  

Total (calculated each quarter)Value D of previous Qtr  + value A of current \Qtr
Column Offset (for each category each quarter)
offset of ATotal- A for current Qtr
Offset of BTotal -  B For Current Quarter
Offset of CTotal -  B - C
Offset of DAlways 0

I need to create a dynamic logic for this, as data for more years may come.

They can be calculated in script or via expressions.

Please suggest. thanks in advance.

Regards

Vidit

1 Reply
karmariv82
Contributor III

Re: Calculated columns using previous values?

Hi Vidit,

Please check the attached qvw for an example of how to calcuate values in script.

Hope it helps.

-- Karla