Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
lessassy
Creator
Creator

Dynamic Target (depending on month value and year)

Hello everyone,

I have a bar chart which display KPI on a monthly basis from 2015 to 2018

KPI Indicator.PNG

Each year I have a monthly  and a weekly target for that KPI, which is for example:

2015: 200 monthly and 50 weekly

2016: 175 monthly and x weekly

2017: 175 monthly and so on

2018: 200 ....

Excel tab.PNG

SO i create a tab where i put very date of the year 2015 2016 2017 and 2018

And I put the kpi.

but 300 is a monthly KPI.

and i would like to display it on a combo chart.

But when i put (=Target' in combo chart reference line it doesn't work.

What function coul I used.

I tried Avg(Target) to have an average from a monthly target but i didn't get any response

I have a master calendar

Do you have a solution ?

Here are my sample files attached.

Thank you

1 Reply
ogautier62
Specialist II
Specialist II

Hi,

maybe you should link your monthly target to month calendar and not day;

also at a level day you can't give a monthly and a weekly target together

regards