Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can i add vertical reference lines for line graph on Qliksense?

Hi,

I would like to add a vertical reference line for line graph on Qliksense. May I know if this is possible? I have a line graph w months as my dimension. I would like to add a vertical line over a certain month to indicate a :change over" in property. Appreciate for the help!

11 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

It is not available as default functionality, but you can create another expression which will have if statement and a value for that, like below.

If(Month = 'Jun',100000)

This will create a straight line for that month.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
anushree1
Specialist II
Specialist II

@kaushiknsolanki ,

I tried the below approach on yearmonth field , it only works when the relavant yearmonth field is selected if not the reference line appears at the start of the graph, could you please help me here , 

I also tried with only and yearmonthnum fields but the result is same 

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

 

Can you share the sample qvf.

 

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
anushree1
Specialist II
Specialist II

Please check the attached file I am trying to create a vertical reference line at 01/05/2017 Start Date.

 

anushree1
Specialist II
Specialist II

@kaushiknsolanki ,

Any suggestions?

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Checking, will reply in sometime.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
miskinmaz
Creator III
Creator III

You need horizontal or vertical reference line.

The method you used is for horizontal line. Just simple use 1000 or any number and no need to us if condition in that case.

anushree1
Specialist II
Specialist II

Vertical.

Can you plz make the change in the file and share it across

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi Check this.


Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!