topic Re: How to plot vertical reference line with labels on either side of the line in QlikView

How to plot vertical reference line with labels on either side of the line

Anonymous — Mon, 23 May 2016 08:49:42 GMT

I need to plot a vertical reference line to show Allocations till previous month and from current month onwards I need to label the graph as Actuals. I have attached a sample graph that I need

I have ProjectMonth on the X axis. Currently the Continuous option is greyed out under the Reference line tab. So I tried to make my dimensions as continuous but my expressions disappear. Can anybody please help how to do it and how to make the necessary labels appear on the right and left side of the graph.

Re: How to plot vertical reference line with labels on either side of the line

jonathandienst — Mon, 23 May 2016 08:53:42 GMT

Is your ProjectMonth field a numeric date field, or is it a string? Continuous axes are not possible with text dimensions.

If you post a sample qvw illustrating the problem, it will be possible to provide more detailed and accurate help.

Re: How to plot vertical reference line with labels on either side of the line

Anonymous — Mon, 23 May 2016 09:01:46 GMT

Hi Jonathan

My X axis is a string. Will post the qvw file in few mins.

Re: How to plot vertical reference line with labels on either side of the line

Anonymous — Mon, 23 May 2016 09:10:27 GMT

Here's my qvw file

Re: How to plot vertical reference line with labels on either side of the line

jonathandienst — Mon, 23 May 2016 09:16:28 GMT

Then convert it during the load to a numeric date field:

LOAD ....

Date#(ProjectMonth, 'MMM-yyyy') as ProjectMonth,

...

Re: How to plot vertical reference line with labels on either side of the line

Anonymous — Mon, 23 May 2016 09:38:10 GMT

I have used monthname( Date#(ProjectMonth, 'MMM-YYYY'),0) as ProjectMonth, in the script during load. When I plot the graph it show the X axis in digits for 42... etc not the regular months.

I also tried using the Continuous option in the reference chart with the following expression but it doesn't seem to work

count(if(ProjectMonth< MonthName(today()) and aggr(sum({<PlanType={'Actuals'}>}HCM),ProjectMonth,[Resource ID] )<=0.7, [Resource ID],
if(ProjectMonth>= MonthName(today()) and aggr(sum({<PlanType={'Allocation'}>}HCM),ProjectMonth,[Resource ID] )<=0.7, [Resource ID]

)

))

Re: How to plot vertical reference line with labels on either side of the line

Anonymous — Mon, 23 May 2016 09:46:25 GMT

I managed to get the vertical line but I am not able to get the labels to appear on the top.. Any suggestions?