10 Replies Latest reply: Apr 15, 2015 6:17 AM by Joanna Seldon

Reference Line in Bar Chart - Manual Points

Hiya

I wish to add a reference line in a bar chart.

I have found how to do this, but I wish to add a number of values - points on it manually.

not just e.g 300 straight across the chart.

on the bar graph I have number of pupils attending after school club per month,

but each month has a different target number.

Kind Regards

Joeybird

• Re: Reference Line in Bar Chart - Manual Points

Hiya

thanks for the reply, I am using Qlik sense...

Kind Regards

Joeybird

• Re: Reference Line in Bar Chart - Manual Points

Check out the last few posts (and answer marked correct) in this thread

The member was asking the same thing . They wanted a non-constant reference line. In the end we used  a special dimension built in the load script to use in the chart that incorporated the reference line as PART of the dimension.

Adding Avg line in a line chart

• Re: Reference Line in Bar Chart - Manual Points

Hiya

this is not what after sorry, that's done using calculations on data. great through for future reference however

I just want to add manual numbers point reference dots / line per month, as it could change.

e.g

Jan = 300

Feb = 300

March = 450

but these points could change too

Jan = 350

Feb = 300

March = 500

Kind Regards

Joeybird

• Re: Reference Line in Bar Chart - Manual Points

Hiya

I have come up with the idea of creating an excel sheet with the following to help with the query above

 SetNumber Month 8000 Jan 8500 Feb 9000 Mar 8000 Apr 5500 May 9000 Jun 9000 Jul 9500 Aug 6500 Sep 10500 Oct 9400 Nov 9000 Dec

is there a way of adding this "set number" (Manual Points) as a measure (this will be the "line" / "reference line" in a combo chart)?

e.g so when 2014 is selected it shows the number pupils per month as a bar, the line on the combo chart will be the figures from this excel sheet?

Kind Regards

Joeybird

• Re: Reference Line in Bar Chart - Manual Points

hmm... i only see a difference if you decided not to put those data values in the data model.

-Jonnny

• Re: Reference Line in Bar Chart - Manual Points

Yes these values will have to be kept separate from the data model

this is because government could randomly change these target numbers at random,

main data comes from the SQL server, so its easier to go to an excel sheet to update these set manual figures on demand, and load the data.

if I use sum or count [Set Number], I just get one set figure e.g 8000, for each month, where I need to just say, the different set numbers.

is there away of just saying NOT TO count or sum.... just

 8000 Jan 8500 Feb 9000 Mar

ect ...

Kind Regards

JoeyBird

• Re: Reference Line in Bar Chart - Manual Points

Not if its a reference line.

In short you need to make the reference line part of dimension through the technique in the aforementioned link.  You can load the month/target data from a spreadsheet to do this.

I put a sample together (attached) that loads the main data and the setnumber from 2 sources does it help ?

• Re: Reference Line in Bar Chart - Manual Points

Hiya

did try however

I says error, cannot find ChartDimTable:

Kind Regards

Joeybird

• Re: Reference Line in Bar Chart - Manual Points

Hiya

sorted , thank you using your example above needed

SetNumber,

"Month",

'SetNumber' as ChartDim

FROM [lib://C:/SetNumbersRefLine.xlsx]

(ooxml, embedded labels, table is Sheet1);

Thanks all xxx

Kind Regards

Joeybird