topic Re: How to add reference line range on dates in QlikView

How to add reference line range on dates

mayankraoka — Mon, 09 May 2016 18:47:51 GMT

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

Re: How to add reference line range on dates

MarcoWedel — Mon, 09 May 2016 22:49:09 GMT

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

thanks

regards

Marco

Re: How to add reference line range on dates

mayankraoka — Tue, 10 May 2016 03:58:00 GMT

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 !

Re: How to add reference line range on dates

Anonymous — Tue, 10 May 2016 04:23:08 GMT

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

Re: How to add reference line range on dates

Anonymous — Tue, 10 May 2016 04:25:41 GMT

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

Re: How to add reference line range on dates

jonathandienst — Tue, 10 May 2016 04:57:28 GMT

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

Re: How to add reference line range on dates

MarcoWedel — Tue, 10 May 2016 21:18:35 GMT

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

Re: How to add reference line range on dates

Saravanan_Desingh — Wed, 11 May 2016 00:59:26 GMT

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.

Re: How to add reference line range on dates

MarcoWedel — Wed, 11 May 2016 21:26:48 GMT

Hi,

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

regards

Marco