topic Re: how to display actual # in a % barchart expression in QlikView

how to display actual # in a % barchart expression

lmonincx — Fri, 21 Nov 2014 07:29:07 GMT

Hi,

I have a bar chart with an expression like 52,7 % as outcome, i would like to put in that barchart besides the 52,7 % as value on datapoints the actual number for example 600

please attached example

is this possible?

kind regards,

Linda Monincx

Re: how to display actual # in a % barchart expression

anbu1984 — Fri, 21 Nov 2014 07:39:17 GMT

Check this

Re: how to display actual # in a % barchart expression

jyothish8807 — Fri, 21 Nov 2014 08:03:58 GMT

Hi Linda,

Can you please let us know what is 600? is it a result of a expression or you simply want to put it as a text on the bar?

If it is an expression then you can get it by using the solution given by anbu cheliyan.

Regards

Re: how to display actual # in a % barchart expression

lmonincx — Fri, 21 Nov 2014 11:34:39 GMT

600 is just a number I want to show, preferable behind the values expression of the %.

I can't get the formula work from anbu, maybe due to the fact that my calculation is using a count with a lot of set analysis used.

can it be possible to merge text with the outcome of the expression?

I am not that familiar with the settings behind the expression like show value when you click on the + of the expression

Re: how to display actual # in a % barchart expression

anbu1984 — Fri, 21 Nov 2014 11:38:35 GMT

Dual(Your_expression & ' 600',Your_expression)

Re: how to display actual # in a % barchart expression

jonathandienst — Fri, 21 Nov 2014 11:54:53 GMT

Linda

If you change the chart type to a combo chart and then do this:

Set the display method for expression 1 to a bar
Add a second expression which calculates the number you want to display
For this expression clear the line, bar and symbol options and select the display value on data points option
In the Numbers tab, set the number format you want

HTH

Jonathan

Re: how to display actual # in a % barchart expression

jyothish8807 — Fri, 21 Nov 2014 12:00:24 GMT

Hi Linda,

Can you share your app?

As per my understanding you require different numbers for differet color bar? Am i right.

try like this:

if(Month='Feb',dual(Sum(sales) & '600',Sum(sales)),Sum(sales))

Hope it helps.

Regards