Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

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

1 Solution

Accepted Solutions

Re: Bar Chart - Value on Data Point and Symbol

See attached qvw.


talk is cheap, supply exceeds demand
9 Replies

Re: Bar Chart - Value on Data Point and Symbol

See attached qvw.


talk is cheap, supply exceeds demand
thornofcrowns
Valued Contributor II

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.

Not applicable

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!

Not applicable

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

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.


talk is cheap, supply exceeds demand
thornofcrowns
Valued Contributor II

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.

mphekin12
Valued Contributor

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!

Not applicable

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.


talk is cheap, supply exceeds demand
Community Browser