Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
MVP & Luminary
MVP & Luminary

Re: Bar Chart - Value on Data Point and Symbol

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

9 Replies
MVP & Luminary
MVP & Luminary

Re: Bar Chart - Value on Data Point and Symbol

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

Highlighted
Specialist II
Specialist 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.

Highlighted
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!

Highlighted
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

Highlighted
MVP & Luminary
MVP & Luminary

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
Highlighted
Specialist II
Specialist 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.

Highlighted
Specialist
Specialist

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!

Highlighted
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

Highlighted
MVP & Luminary
MVP & Luminary

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