Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Reference line in the chart

Hi All,

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

1 Solution

Accepted Solutions
preminqlik
Valued Contributor II

Re: Reference line in the chart

Hi Ravi if you write Date(date,'MMM-YYYY') , if the field date is in time format then you'll face the problem in frontend , it will give repeated values in list box

to avoid that use the floor function before as follows

date(floor(num(date)),'MMM-YYYY')

View solution in original post

26 Replies
thornofcrowns
Valued Contributor II

Re: Reference line in the chart

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

MVP
MVP

Re: Reference line in the chart

Hi

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

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Not applicable

Re: Reference line in the chart

HI jonathan,

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

veidlburkhard
Contributor III

Re: Reference line in the chart

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

Partner
Partner

Re: Re: Reference line in the chart

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
Contributor III

Re: Reference line in the chart

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:

ReferenceLine.jpg

This is the easy way...

Regards

Burkhard

Not applicable

Re: Re: Reference line in the chart

Hi Burkhard,

  if i am using dates it is showing like this PFA

Not applicable

Re: Reference line in the chart

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
Contributor III

Re: Reference line in the chart

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:

ReferenceLine.jpg

Enjoy

Burkhard