Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand

View solution in original post

9 Replies
Gysbert_Wassenaar

See attached qvw.


talk is cheap, supply exceeds demand
ThornOfCrowns
Specialist II
Specialist II

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

Not applicable
Author

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
Author

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.


talk is cheap, supply exceeds demand
ThornOfCrowns
Specialist II
Specialist II

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
Specialist
Specialist

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
Author

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.


talk is cheap, supply exceeds demand