How to add reference line range on dates

[mayankraoka]

Hi Team,

I have date dimension having format dd-mm-yyyy format on x-axis and sum(sales) on y-axis.I have to certain specific range of date that need to be highlighted.So i need to add starting and ending date reference line for that on x-axis of line chart.I am not getting contious x-axis on presentation reference line section.I need this date range to be dynamic on the basis of source file.In the source file this data range comes with the help of flag where flag is 1 this date max and min should be our reference line.

Can anyone help me on this.

Regards,

Mayank

[MarcoWedel]

please post a sample application where you do not have continuous x-axis / reference lines options.

thanks

regards

Marco

[mayankraoka]

Hi Marco,

Please find sample app where I have taken date in string format(Jan,feb...).The actual date is in dd-mm-yyyy format.

Please let me know in case you need any other info.

Regards,

Mayank !

[Anonymous]

in axes tab have the reference line  by using the reference line you can get the output

[Anonymous]

or have the by using the diagonally arrow available in the qlikview so that you can use that one you can get the reslut may be

[jonathandienst]

Vertical reference lines require a continuous x-axis.You can have dates on a continuous axis, but they do need to proper QV numeric date values. If you are not sure how to get the date values:

Why don’t my dates work?

QlikView Date fields

[MarcoWedel]

Hi,

you don't get a working chart with continuous dimension axis because you don't have dual date values (i.e. with underlying numerical values) in your Date1 field (like Jonathan already suggested). Your Date1 field only holds text values instead.

I think the best approach would be script based. A front end solution however could be a calculated dimension to get numerical dimension values, a continuous dimension axis and reference lines (here defined statically because I didn't find the flags you mentioned) like:

hope this helps

regards

Marco

[Saravanan_Desingh]

Hi marcowedel‌

I tried the same steps you have suggested. But how did u get the MMM even after selecting the 'Continuous' option?

Please see the below screenshot of my chart. Can you please advise, how you get that? Thank you.

[MarcoWedel]

Hi,

change the number format of the continuous x-axis to date/MMM:

regards

Marco