Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
vaisgaard
New Contributor II

Incremental reference line x+y

Hi,

I can't get my head around doing a simple incremental reference line i QS.

Problem:

I have this dataset:

YearWeek   Actual
2019-01      125
2019-02      263
2019-03      352
2019-04      589
2019-05   785

I want to create a reference line with my target for performance. The target pr. week is 500.

I hope someone can help.

Best regards

Michael

Labels (1)
2 Replies
Support (Former)
Support (Former)

Re: Incremental reference line x+y

Hi, can you  further elaborate how the incremental reference line should look like? If it's only about comparing weekly actuals against a fixed target per week of 500, then it's a fixed reference line with expression = 500 (see image below).

 

refLine.png

Vu Nguyen
If a post helps resolve your issue, please mark the answer as correct.
vaisgaard
New Contributor II

Re: Incremental reference line x+y

Hi Vu,

Yes of course.

The  target shall increment by 500 every week. I hope that clarifies it.

Best regards

Michael