topic Veritcal reference line in QlikView

Veritcal reference line

jduenyas — Wed, 25 Nov 2020 16:16:04 GMT

Hello gurus

I needed a vertical reference line in my chart which is based on month/year dimension.

Before applying the vertical reference line the chart looked like so:

In order to get the vertical reference line I had to change the Dimension Axis to Continuous. But that changed the displayed values of the dimension and added a semi monthly grid. Here it is:

How can I format the Dimension to show MonthName (month and year as above) which is not in the Number formatting tab and how can I get rid of the "mid month" grid?

Thanks

Josh

Re: Veritcal reference line

maheshkuttappa — Wed, 31 Aug 2016 20:02:48 GMT

Can you post the QVW with sample data ?

Re: Veritcal reference line

jduenyas — Wed, 31 Aug 2016 20:06:48 GMT

the app is way too large.

I will try to set a smaller sample

Re: Veritcal reference line

MarcoWedel — Wed, 31 Aug 2016 23:32:56 GMT

Hi,

seems to work with 'MMM YYYY' as date format:

hope this helps

regards

Marco

Re: Veritcal reference line

jduenyas — Wed, 31 Aug 2016 23:56:03 GMT

Marco you are the best.

however why do I get a Mid Month grid?

Re: Veritcal reference line

Thu, 01 Sep 2016 01:09:51 GMT

Had the same problem just the other day. To fix it I replaced my SalesDate dimension with the following expression:

=Date(MonthStart(SalesDate),'MMM-YYYY')

The MonthStart function will convert all dates to the first day of the month. So, 7/15/2016 will become 7/1/2016, etc.

Will this work for you?

- Stan

Re: Veritcal reference line

Anil_Babu_Samineni — Thu, 01 Sep 2016 04:03:53 GMT

Give 50% of reference

Re: Veritcal reference line

stabben23 — Thu, 01 Sep 2016 05:44:34 GMT

Hi,

from where does Your month/year Dimension comes from? is it from a calender or is the Field concatenated in a fact table With sales and Budget? This is probably datamodel related.

Re: Veritcal reference line

jduenyas — Thu, 01 Sep 2016 15:28:48 GMT

Cannot because the Definition>Percentile is grayed out.

Thanks though

Re: Veritcal reference line

jduenyas — Thu, 01 Sep 2016 15:29:16 GMT

The date is from the Calendar

Re: Veritcal reference line

jduenyas — Thu, 01 Sep 2016 15:33:55 GMT

Sounded logical but it does not work. My dimension is of the format MMM YYYY to begin with and does not contain any other dates except for the Month and Year.

Thanks though

Re: Veritcal reference line

stabben23 — Fri, 02 Sep 2016 05:17:36 GMT

Hi,

can you give us the Expression in the chart and a tableview of the model.

Re: Veritcal reference line

Peter_Cammaert — Fri, 02 Sep 2016 07:39:57 GMT

The mid-month labels are a result of converting your X-axis to a Continuous type. The axis itself will contain all integer values between each first-of-the-month day, whether you want it or not, whether your series contains other data points aside from the first of the month values or not.

What you are asking for is a Continuous axis that displays discreet values (just the first of the month) which leads to an infight in the display engine

AFAIK there is no works-in-all-cases solution to this. The best thing you can do is tweak the graph and X-axis so that it shows at most one label for every month, like Marco seems to have managed in his example. As soon as the content or scaling of the graph changes however, you may be in trouble again. Sorry.

Peter

Re: Veritcal reference line

MarcoWedel — Sat, 03 Sep 2016 23:07:05 GMT

Hi,

if you can't use continuous x-axis then maybe you could use some other mean to mark specific dates (here one example for a bar chart instead of a line chart):

Re: In a chart - can I show "today"?

hope this helps

regards

Marco