topic Re: Bar chart with values in brackets in QlikView

Bar chart with values in brackets

Wed, 04 Feb 2015 03:52:59 GMT

Hi,

I have a requirement where I need to show sales Bar and value of change in sales from previous day in brackets at the end of the bar.

PFA the demo app.

Regards

Navdeep

Wed, 04 Feb 2015 04:09:41 GMT

Could you please post a screenshot of your requirement?

Wed, 04 Feb 2015 04:27:13 GMT

Hi,

Something like this, change from last day value in bracket.

jonasheisterkam — Wed, 04 Feb 2015 05:02:28 GMT

Hi,

You can use Dual() :

=dual( sum(Sales) & ' (' & sum(SalesPD) & ')' , sum(Sales) )

=dual( 'Expression for Text you want show' , Expression with Chart Value )

mdmukramali — Wed, 04 Feb 2015 05:12:00 GMT

Dear,

use the below expression

=dual( Sum([Sales]) & ' (' & ((Sum([SalesPD]))) & ')',(sum([SalesPD])) )

deepakqlikview_123 — Wed, 04 Feb 2015 05:27:30 GMT

use dual function