topic Re: Can i add vertical reference lines for line graph on Qliksense? in App Development

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

Wed, 12 Jul 2017 02:16:12 GMT

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!

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

kaushiknsolanki — Wed, 12 Jul 2017 07:25:40 GMT

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

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

anushree1 — Wed, 31 Jul 2019 07:23:48 GMT

@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

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

kaushiknsolanki — Wed, 31 Jul 2019 13:08:22 GMT

Hi,

Can you share the sample qvf.

Regards,

Kaushik Solanki

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

anushree1 — Thu, 01 Aug 2019 10:12:20 GMT

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

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

anushree1 — Fri, 02 Aug 2019 05:29:39 GMT

@kaushiknsolanki ,

Any suggestions?

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

kaushiknsolanki — Fri, 02 Aug 2019 05:47:04 GMT

Hi,

Checking, will reply in sometime.

Regards,

Kaushik Solanki

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

miskinmaz — Fri, 02 Aug 2019 05:48:43 GMT

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.

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

anushree1 — Fri, 02 Aug 2019 05:50:15 GMT

Vertical.

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

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

kaushiknsolanki — Fri, 02 Aug 2019 05:57:26 GMT

Hi Check this.

Regards,

Kaushik Solanki

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

anushree1 — Fri, 02 Aug 2019 06:17:00 GMT

Hi Kaushik,

I tried this approach to get the Reference Line on my real time data as vertical reference line , but it appears on the starting of the chart as per the image attached, when I select YearMonth as 201706 it appears at the correct position but otherwise it does'nt.

Any reason for the behaviour?

Please note I am using a Vizlib Extension with 20 Ticks on my X:axis

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

kaushiknsolanki — Fri, 02 Aug 2019 08:02:07 GMT

Hi,

Difficult to say what would be wrong. I would suggest you contact Vizlib and check with them.

Regards,

Kaushik Solanki