Bar Chart - Value on Data Point and Symbol

[#1]

Hi - I'm relatively new to Qlik but getting better everyday.  I have a simply bar with a % at the top and curious is I also add a symbol, colored circle as well.  Appreciate any insights....

Current

Goal

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[ThornOfCrowns]

If that symbol is shown when the bar is over the average line, it might be better to colour the bar itself.

[#4]

Gysbert - thanks for your reply, this is precisely what I am looking to do.  One quick follow up thought.  Can you explain the Dual function a bit.  Not sure I fully understand it.  The first part merges the number and the symbol, is that correct?  If so, what is the purpose of the second, sum(sales)?

dual( floor(sum({<Product>}Sales)/1000) & ' K ●' ,sum(Sales))

Many, many thanks!

[#5]

Thanks James - unfortunately the chart has YTD and a Forecast number across many offices and the when I add colors, the graph becomes way too busy and is very hard to read.

Thanks

[Gysbert_Wassenaar]

The dual function give a numeric value an additional text representation, i.e. formatting. The first part is creates the text representation, the second part the numeric value.

[ThornOfCrowns]

The sum(sales) at the end of the DUAL expression is the distance from the bottom of the bar, so the symbol appears at the top.

[mphekin12]

Gysbert,

Can you please explain how your average trend line is coming up with 533036.24?  If the total sum is 5330362.43 and there are 9 products, shouldn't the average be 592262.49?  It might help me understand the aggr() function a little more.

Thanks!

[#9]

Gysbert - one last question for you please...is it possible to make the circle bigger at all?

-Michael

[Gysbert_Wassenaar]

Maybe. Perhaps you can find a font with a character that fits your requirements.