9 Replies Latest reply: Mar 6, 2015 12:29 PM by Gysbert Wassenaar

# Bar Chart - Value on Data Point and Symbol

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

• ###### Re: Bar Chart - Value on Data Point and Symbol

See attached qvw.

• ###### Re: Bar Chart - Value on Data Point and Symbol

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!

• ###### Re: Bar Chart - Value on Data Point and Symbol

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.

• ###### Re: Bar Chart - Value on Data Point and Symbol

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

-Michael

• ###### Re: Bar Chart - Value on Data Point and Symbol

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

• ###### Re: Bar Chart - Value on Data Point and Symbol

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.

• ###### Re: Bar Chart - Value on Data Point and Symbol

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!

• ###### Re: Bar Chart - Value on Data Point and Symbol

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

• ###### Re: Bar Chart - Value on Data Point and Symbol

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