Reference line in the chart

[#1]

Hi All,

  I want to show a reference line vertically in the chart when an event occurs in the particular month. PFA

[ThornOfCrowns]

Can you give an example of the event that wouod trigger the "reference line"?

[jonathandienst]

Hi

For a vertical reference line, you need to enable continuous mode for the x-axis (Properties | Axes).

HTH

Jonathan

[#4]

HI jonathan,

     i want to display the events as reference lines at that respective month how can i get that??

[veidlburkhard]

Hi Kannuri,

for vertical reference lines you need a continous x axis. So you better should use dates instead of month. Please look at this training video for explanation:

Qlikview Vertical Reference Lines by RFB 147 - YouTube

Hope this helps

Burkhard

[jagannalla]

Plz check the attached file. You need to add reference line for each dimensions value. It is not full solution, I'm giving just idea.

Hope you will get better solution from others.

[veidlburkhard]

Hi Kannuri,

a very simple solution to your problem could be to ad a second expression event with vertical labels. This would look like below:

This is the easy way...

Regards

Burkhard

[#8]

Hi Burkhard,

  if i am using dates it is showing like this PFA

[#9]

Hi jagan,

   Thanks for your response but here the month no  dimension is showing some invalid values??

may i know why it is showing like that?? (we have monthno as  only 1,2 )

[veidlburkhard]

Hi Kannuri,

this is only cause your date format in the expression for the reference line was slightly incorrect. You have to use

Date#('01-06-2014', 'DD-MM-YYYY') then everything looks fine:

Enjoy

Burkhard