Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Contributor II

Derive Target line based on Actual Data

Hello Community,

I need to derive “Target” line based on the actual data. The data is displayed in quarters and the first quarter value is  considered as the base value for Target from there on for each quarter there should be 2.5% decrease(in a year 10% decrease).

For example if the Q1 Actual data is 10159 then the start for “Target” is 10159 for Q2 the Target should be 9897, Q3-9638, and Q4-9377

I hope the requirement is clear and makes sense. Thank you,

Ramya

1 Solution

Accepted Solutions
Highlighted

Re: Derive Target line based on Actual Data

Try this

If(RowNo() = 1, sum([Actual Data]), Sum(TOTAL Aggr(If(Quarter = MinString(TOTAL Quarter), sum([Actual Data])), Quarter)) * (1 - ((RowNo()-1) * 0.025)))

View solution in original post

2 Replies
Highlighted

Re: Derive Target line based on Actual Data

Try this

If(RowNo() = 1, sum([Actual Data]), Sum(TOTAL Aggr(If(Quarter = MinString(TOTAL Quarter), sum([Actual Data])), Quarter)) * (1 - ((RowNo()-1) * 0.025)))

View solution in original post

Highlighted
Contributor II

Re: Derive Target line based on Actual Data

Thank you very much Sunny. I really appreciate it.

Ramya