Qlik Community

Ask a Question

App Development

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

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
vaisgaard
Contributor III
Contributor III

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
Vu_Nguyen
Support (Former)
Support (Former)

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
Contributor III
Contributor III
Author

Hi Vu,

Yes of course.

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

Best regards

Michael