Insert marker or reference line into Bar Chart

[#1]

[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.

[#2]

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

[#3 · Accepted solution]

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.....

[#4]

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

[#5]

[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.