Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rajany089
Contributor II
Contributor II

Dynamic Reference Line

Hello Team, I need to create a dynamic reference line for a bar graph. The reference line should start at 73% for January 2024 and increase by 3% each month thereafter. Currently, I have data for two months, but I want the reference line to adjust automatically as new data is added. How can I achieve this without manual intervention, ensuring the reference line reflects the correct percentage for each month?

 

Code that i tried 

 

if (Month = 'Jan-2024' THEN '70%',
elseif Month = 'Feb-2024' THEN '73%',
elseif Month = 'Mar-2024' THEN '77%',
elseif Month = 'Apr-2024' THEN '80%',
elseif Month = 'May-2024' THEN '83%',
elseif Month = 'Jun-2024' THEN '87%',
elseif Month = 'Jul-2024' THEN '90%',
elseif Month = 'Aug-2024' THEN '93%',
elseif Month = 'Sep-2024' THEN '97%',
else '100%')
ENDIF

 

here month is column name 

Labels (1)
1 Reply
JonnyPoole
Employee
Employee

Can you send a picture of what you want?  If the months are on the X axis the reference line would not be flat or constant.  Do you use the maximum month in the data set to calculate the reference line amount?  I think a picture might explain what you are after.