# 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

Tags (6)
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
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
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.

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