topic Draw a line between two calculated fields in QlikView

Draw a line between two calculated fields

Fri, 22 Oct 2010 07:07:50 GMT

Hi Experts

Pls find the attached dashboard and expected dashboard, below table is the source file for the dashboard.

Year /Quarter	Product	Price
201001	LAPTOP	24000
201001	LAPTOP	23450
201001	LAPTOP	21455
201001	LAPTOP	63221
201001	LAPTOP	67634
201001	LAPTOP	14335
201001	LAPTOP	67533
201001	LAPTOP	15457
201002	LAPTOP	44275
201002	LAPTOP	35432
201002	LAPTOP	55842
201002	LAPTOP	95657
201002	LAPTOP	45423
201002	LAPTOP	34765
201002	LAPTOP	35462
201003	LAPTOP	87674
201003	LAPTOP	85645
201003	LAPTOP	53644
201003	LAPTOP	54343
201003	LAPTOP	46242
201003	LAPTOP	45467
201003	LAPTOP	46442
201003	LAPTOP	43323
201003	LAPTOP	65623
201003	LAPTOP	57656

I am taking year / Quarter field on x-axis and Count(product) on y-axis (which will be in BAR CHART)

In my example I have added two more calculated fields in expression tab.

Count(product)+5 and Count(product)-5. (Which will be Symbol in display option).

Now I want to draw a line in between Count(Product)+5 and Count(product)-5. pls see the attached screenshot for clarification.

So how to achieve this to draw a line between these two calculated fields.

Thanks,

Draw a line between two calculated fields

hdonald — Fri, 22 Oct 2010 08:29:33 GMT

Hi,

How about dropping an error bar down from the top expression ? Make it = Count(product)+10 and it should cover the gap ?

Regards,

Draw a line between two calculated fields

Fri, 22 Oct 2010 08:36:52 GMT

No, its not working..

Thanks,

Draw a line between two calculated fields

hdonald — Fri, 22 Oct 2010 08:45:55 GMT

My mistake...just make the Error Below = 10

Draw a line between two calculated fields

Fri, 22 Oct 2010 09:02:42 GMT

HD, I believe I have mentioned clearly what I required.

I need veritical line not horizontal line and it should be between two values that count(product)+5 and Count(product)-5.

Thanks,

Draw a line between two calculated fields

Mon, 25 Oct 2010 14:30:54 GMT

Hi Experts,

Any idea on this question?

Thanks,

Draw a line between two calculated fields

hdonald — Mon, 25 Oct 2010 17:02:07 GMT

Error bars are, mostly, vertical.....

Draw a line between two calculated fields

Tue, 26 Oct 2010 07:26:28 GMT

Hi HD,

I am struggling to get this done, pls let me know what is the properties should I need to select for Count(product)+5 and Count(product)-5.

pls guide me.

Thanks,

Draw a line between two calculated fields

hdonald — Tue, 26 Oct 2010 08:51:30 GMT

In the Expressions tab select the Count(Product) expression and tick the 'Has Error Bars' tick box.

Click on the '+' next to that expression and select an error bar e.g. 'Error Symmetric' and make the definition =5 (or select one of the other error bars and try different definitions to get the particular effect you want).

You can add conditional logic in the definition to control when the bars appear.

On the Presentation tab you can control the width and colour of the Error bars which can make them blend in a bit more and also fiddle with the default symbol size to make then line up with the error bar ending.

Using Error bars like this on expressions for emphasis or to get reference lines on the x-axis is an old Excel chart trick.

I'm not able to upload qvw files at the moment so I hope this is enough description,

Regards,

Draw a line between two calculated fields

Tue, 26 Oct 2010 11:38:15 GMT

Thanks HD, it really helps me a lot..

Thanks,

Draw a line between two calculated fields

Tue, 02 Nov 2010 07:02:24 GMT

Hi HD, there is one more issue has come,

when I select particular year, the error bars values end out of the chart scale.

Do you have any option to select the error bars value should not out.

Thanks,

Draw a line between two calculated fields

Tue, 02 Nov 2010 09:30:21 GMT

Nope, I got the solution.

Thanks,

Draw a line between two calculated fields

Tue, 02 Nov 2010 10:51:57 GMT

Hi HD,

I would like put one message in the BAR chart.

Condition is : If Count(Product)<5 then Chart should be blank with the message "No product calculation because the Count(Product)<5"

How to implement this, pls guide me.

Thanks,

Draw a line between two calculated fields

Tue, 02 Nov 2010 11:39:48 GMT

Hi tims,

You can write Your condition in "calculation condition" (in chart general tab), then in "error messages" (The same tab) option input Your message.

Enjoy

Draw a line between two calculated fields

Tue, 02 Nov 2010 11:39:52 GMT

Hi tims,

You can write Your condition in "calculation condition" (in chart general tab), then in "error messages" (The same tab) option input Your message.

Enjoy

Draw a line between two calculated fields

hdonald — Tue, 02 Nov 2010 12:06:09 GMT

Hi,

I might try adding an 'IF' statement wrapper around your error bar expression like if(Count(Product)>=5,5) to only show the error bar if values, in a given month, are in the range you want.

Then add another expression with a similar 'IF' condition to display your error message if count <5.

Make sure this expression has no line or symbol but does have either 'Values on Data Points' or 'Values on Axis' depending on where you'd prefer the text to appear.

The presentation tab has some options to show data points inside a segment (maybe vertical) for text in bar style,

Regards,