topic Re: Reference Line in Bar Chart - Manual Points in App Development

Reference Line in Bar Chart - Manual Points

joeybird — Mon, 13 Apr 2015 13:16:40 GMT

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.

how would i go about this please?

Kind Regards

Joeybird

Re: Reference Line in Bar Chart - Manual Points

Gysbert_Wassenaar — Mon, 13 Apr 2015 13:29:19 GMT

See this blog post: Bar chart target lines in QlikView The Qlik Fix!

Re: Reference Line in Bar Chart - Manual Points

joeybird — Mon, 13 Apr 2015 13:36:26 GMT

Hiya

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

any further ideas please?

Kind Regards

Joeybird

Re: Reference Line in Bar Chart - Manual Points

JonnyPoole — Mon, 13 Apr 2015 15:35:31 GMT

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

joeybird — Tue, 14 Apr 2015 08:21:58 GMT

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

joeybird — Tue, 14 Apr 2015 13:56:03 GMT

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?

Please help

Kind Regards

Joeybird

Re: Reference Line in Bar Chart - Manual Points

JonnyPoole — Tue, 14 Apr 2015 14:03:13 GMT

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

Can you upload a reloadable sample with test data ?

-Jonnny

Re: Reference Line in Bar Chart - Manual Points

joeybird — Tue, 14 Apr 2015 14:22:17 GMT

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

JonnyPoole — Tue, 14 Apr 2015 15:03:01 GMT

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

joeybird — Wed, 15 Apr 2015 09:25:48 GMT

Hiya

did try however

I says error, cannot find ChartDimTable:

Kind Regards

Joeybird

Re: Reference Line in Bar Chart - Manual Points

joeybird — Wed, 15 Apr 2015 10:17:09 GMT

Hiya

sorted , thank you using your example above needed

LOAD

SetNumber,

"Month",

'SetNumber' as ChartDim

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

(ooxml, embedded labels, table is Sheet1);

Thanks all xxx

Kind Regards

Joeybird