topic Re: Adjusting a Reference Line in QlikView

Adjusting a Reference Line

Wed, 09 Dec 2015 21:45:58 GMT

Expert Community. I am trying to figure out how to write an expression in the Reference Line area where I can adjust a reference line from one value to another mid year. My example is a simple bar chart. I have a bar chart with 13 months (e.g. Nov 14 to Nov 15) where each bar references a value. I have a goal line set at let's say 65%. Beginning halfway through the year the goal line has been adjusted to let's say 75%. How do I write an expression showing the goal line moving from 65% for the first 6 months and then going to the new limit for the remaining 7 months?

Here is an example using a Excel image.

Re: Adjusting a Reference Line

JonnyPoole — Wed, 09 Dec 2015 21:56:07 GMT

i don't think so . Can you just use a combo chart with a bar measure and a line measure ?

Re: Adjusting a Reference Line

Anonymous — Wed, 09 Dec 2015 22:10:33 GMT

you can conditionally hide the reference line.

not sure how it helps here though

Regards

Sri1

Re: Adjusting a Reference Line

Anonymous — Thu, 10 Dec 2015 06:15:25 GMT

Go ahead nd use combo chart you can achived this by writing 2 expressions first expression will be showing your data in bar chart and use second expression for refrence line.

for first expression display option in the expression tab should be bar and for the scond expression it should be line.

for example:

1st exp sum(Sales)

2nd exp sum(if([Month Num]<=6,25,35))

Hope this will help you........!!

Regards,

Sandip Satbhai