topic Bar Chart - Value on Data Point and Symbol in QlikView

Bar Chart - Value on Data Point and Symbol

Thu, 05 Mar 2015 22:48:59 GMT

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

Gysbert_Wassenaar — Fri, 06 Mar 2015 10:17:03 GMT

See attached qvw.

Re: Bar Chart - Value on Data Point and Symbol

ThornOfCrowns — Fri, 06 Mar 2015 10:23:28 GMT

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

Fri, 06 Mar 2015 14:58:04 GMT

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

Fri, 06 Mar 2015 14:59:31 GMT

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

Re: Bar Chart - Value on Data Point and Symbol

Gysbert_Wassenaar — Fri, 06 Mar 2015 15:04:16 GMT

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

ThornOfCrowns — Fri, 06 Mar 2015 15:11:48 GMT

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

mphekin12 — Fri, 06 Mar 2015 15:32:31 GMT

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

Fri, 06 Mar 2015 16:23:38 GMT

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

Gysbert_Wassenaar — Fri, 06 Mar 2015 17:29:27 GMT

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