Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
prachisangewar
Contributor

Dynamic Multiple Vertical Reference Lines in Line Graph

Hi,

I have a line graph with Date as my X Axis.

I need to have reference lines on all Month End dates.I have created a flag for Month End dates in my Calendar table.

Please suggest if I can show multiple lines using a single expression.

I have tried to give condition in the Expression but the line does not show.It only works if I have just one Date (e.g I tried with Max Date Variable).

Please advise!

5 Replies
prieper
Honored Contributor II

Re: Dynamic Multiple Vertical Reference Lines in Line Graph

Think not, that this is possible with reference lines (output is always one value to my understanding).

But you may choose a different color for your bars or datapoints, depending the date.

Peter

serj_shu
Valued Contributor

Re: Dynamic Multiple Vertical Reference Lines in Line Graph

Hi, Prachi!

If you use a line chart you can try to convert it into a combo chart, next you can add a bars which will be your vertical lines. You also can make it less noticeable with transperacy. The calculated value of bars may be the max value among the all values of line.

P.S.: reference lines is the only horizontal lines

P.P.S.: one expression = one reference line

Frank_Hartmann
Honored Contributor

Re: Dynamic Multiple Vertical Reference Lines in Line Graph

prachisangewar
Contributor

Re: Dynamic Multiple Vertical Reference Lines in Line Graph

Hi Frank,

Thanks for the suggestion, but the Error bar doesn;t seems to show my last monthend date(eg if I select Jan t0 Dec 2016, the error bars appear only till 30th Nov), but the Symbols are shown for all the MonthEnds.So my expression is ok.Any her setting I need to change for the Error Bars?

Thanks

Frank_Hartmann
Honored Contributor

Re: Dynamic Multiple Vertical Reference Lines in Line Graph

Please prepare a small sample which demonstrates the problem.

Community Browser