topic Re: reference line in QlikView

reference line

cbushey1 — Wed, 27 Jun 2018 17:08:54 GMT

Hello there,

Looking to add a reference line to a horizontal bar chart. Normally this is pretty easy using the presentation tab, reference line, but my dimension causes some issues.

My dimension is a field where the values are a range, '0-19', '20-39', etc. I want to assign a reference line at a particular point, say 40.

Re: reference line

MarcoWedel — Wed, 27 Jun 2018 21:11:29 GMT

So you don't have a continuous dimension axis?

Re: reference line

BalaBhaskar_Qlik — Thu, 28 Jun 2018 16:43:09 GMT

May be like:

Change the Axes as Continuous, Now add the reference value in Expression area as 40 and check.

Re: reference line

cbushey1 — Thu, 28 Jun 2018 23:31:52 GMT

I suppose I don't since that option is grayed out. The field I am using for the dimension is a string, i.e. 0-29 is a value for the field.

Re: reference line

romansavchuk — Sat, 30 Jun 2018 11:49:54 GMT

I have one solution.

This may be not best practice to use combo chart line as reference line, but it may be suitable for this case.
Example application in attachment.

Re: reference line

MarcoWedel — Sat, 30 Jun 2018 15:56:56 GMT

Where is the point 40 on this discrete axis?

Re: reference line

cbushey1 — Sat, 30 Jun 2018 16:07:00 GMT

I am not sure I follow you Marco. The axis is a single field where the values are ranges of 30. What I want to do is draw a line at a fixed point, say 40, that could be drawn over the bars.

Re: reference line

romansavchuk — Sat, 30 Jun 2018 19:10:54 GMT

Dear Chase Bushe‌‌,

Can you post example of chart (picture in paint or application example) for better understanding, what you wanna to see, because I imagine it as in the picture "Chart example.png" in attachments, but I am not sure, you can do it with QlikView (I may mistake, but i haven`t see such configuration of reference line).

May be colorizing of bar with certain number can solve your problem. (using background color in expression as in attached example).

Re: reference line

cbushey1 — Fri, 06 Jul 2018 20:43:17 GMT

Sorry for the delay, work deadlines.

Your Chart Example.png file is exactly what I am hoping to achieve, but given my dimensions are not continuous I am not sure how to accomplish this. I looked at your .qvw but that doesnt show the line, only the background coloring.

Re: reference line

cbushey1 — Fri, 06 Jul 2018 20:51:45 GMT

I cant use this approach because the line is vertical. I need the line to be on the same axis as the bars.

Re: reference line

romansavchuk — Sat, 07 Jul 2018 16:34:14 GMT

May be this chart helps you

I draw at the selected bar one background bar. - it`s not reference line on selected dimension, but maybe it helps you.

I had investigate a lot of resources, but i haven`t found anything with reference line as on the Chart Example.png.

May be extensions such Google Charts has such functionality, because QlikView as I see allow this only for continuous dimension.

Re: reference line

MarcoWedel — Sun, 08 Jul 2018 00:39:25 GMT

Hi,

maybe one solution could be:

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

hope this helps

regards

Marco

Re: reference line

cbushey1 — Mon, 09 Jul 2018 20:32:47 GMT

Marco,

This is an interesting approach, but I dont think it will work in this case.

This solution requires the x-axis to be marked as continuous and if I do that, I lose the true value of the field (as it changes to a number).

0-19 becomes 0

20-39 becomes 20

...

Since there is no number option for string, I am not sure how to get the true labels back.

This did get me thinking though. I wonder if I could create this field as a dual so that the range is the string, and assign a value to the second part). Doing that might just allow for a continuous axis.

Re: reference line

MarcoWedel — Mon, 09 Jul 2018 22:51:36 GMT

I'm not quite sure whether a continuous valued reference line in between discrete bars makes much sense but one way to do so might be:

hope this helps

regards

Marco

Re: reference line

cbushey1 — Mon, 30 Jul 2018 17:10:56 GMT

Marco,

Thank you for putting together this example and taking the time to outline the steps. I apologize for not getting back to you sooner but I just had the chance to review this.

I cant seem to make this work for me.

My dimension is a field, Patient_MME_Bucket. It is based on the actually score in Patient_MME_Score, but it already represents the bucket, i.e. "0-19", or "30-49".

One potential problem is that my numbers get quite large, 1000's. Not sure if that is the reason, but my bars dont actually line up with the new labels.

Re: reference line

MarcoWedel — Mon, 30 Jul 2018 19:47:10 GMT

Hi,

can you create a small set of sample data (incl. your Patient_MME_Bucket field) and your required result based on this data to get a better impression?

thanks

regards

Marco