topic Re: Showing Value in Bar Chart in QlikView

Showing Value in Bar Chart

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I have a bar chart like this:

My expression is below:

=Dual(Num(Sum(ContractDollars) / Sum(TOTAL <CstFiscalYear> ContractDollars), '#.#%'), Sum(ContractDollars) / 1000000)

Now I want to show the Sales Value as well in Bar just below the Percentage value.

Could you please help me on this.

Thanks,

Sarif

maxgro — Mon, 27 Mar 2017 10:21:32 GMT

maybe with 2 expression

Sum(ContractDollars)

Num(Sum(ContractDollars) / Sum (TOTAL <CstFiscalYear> ContractDollars), '#,##0.0%') &

chr(10) &

Num(Sum (ContractDollars), '#,##0')

for the second expression uncheck bar

and check value on data point

mhmmd_srf — Mon, 27 Mar 2017 10:40:48 GMT

Not working sir..

Please help.

Thanks,

Sarif

maxgro — Mon, 27 Mar 2017 10:53:11 GMT

Example in the attachment

rzenere_avvale — Fri, 14 Apr 2017 15:24:03 GMT

Nice one, thank you!