topic Insert marker or reference line into Bar Chart in QlikView

Insert marker or reference line into Bar Chart

Wed, 12 May 2010 12:03:11 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.02.89.41/Test_2D00_Inserting-Reference-Line-into-Bar-Chart-Sample-20100512000.qvw]

Hi Guys,

Attached a qvw showing a annual sales comparison between 2009 and 2010.

Is there any way to set a "marker" or "reference line" into the bar of "2009" to indicate which was the amount at the same time period?

In example, The sales YTD in 2010 are 7,750

I need to show that the sales for the same period in 2009 were 5,300

Thanks in advance,

Aldo.

Insert marker or reference line into Bar Chart

Wed, 12 May 2010 12:14:16 GMT

Hi,

If i understood your question properly, yo can use combo chart to do your requirement.

Your chart should have one dimension and 2 expression

Expression for bar should be sum of sales i.e sum(Sales)

Add one more expression and your expression should be rangesum(above(sum(Sales),0,rowno())), make this expression has only symbols.

Rangesum expression which ia hve give above is untested.

Dimension should be Year.

Hope this will help you.

-Peterson

Insert marker or reference line into Bar Chart

Wed, 12 May 2010 12:31:26 GMT

Hi Aldo,

This is possible Aldo. in the Presentation tab of the properties window ther is a space where you can specify the reference line. you can click on the add button there and add a reference line there...hope this helps you.

thanks Joseph.....

Insert marker or reference line into Bar Chart

Wed, 12 May 2010 12:37:34 GMT

Yeah, I tried inserting a reference line, but I can not work it around...

Insert marker or reference line into Bar Chart

Wed, 12 May 2010 13:25:06 GMT

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Components.UserFiles/00.00.02.89.41/Test_2D00_Inserting-Reference-Line-into-Bar-Chart-Sample-20100512001.qvw]

Ok, got it! (See attachment).

Thanks,

Aldo.