topic Display % and count in Bar Chart in QlikView

Display % and count in Bar Chart

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

I have an expression for % , how can i display the total value and percentage both on the bar chart below.

Below is the expression

=Num(
Count({<[STATUS]={"COMPLETED"}>}[STATUS])
/
Count({<[TECH]={"POSTGRES","ORACLE","MONGO"}>}[TECH])
, '#.%')

Re: Display % and count in Bar Chart

dplr-rn — Mon, 15 Jul 2019 19:51:49 GMT

Use Dual as expression with Numeric value and text value. and select Value on data point option.

e.g.

expression =Dual(Num(Sum(Sales)/Sum(Total Sales),'###.#%'),Sum(Sales))

Re: Display % and count in Bar Chart

Brett_Bleess — Wed, 07 Aug 2019 20:37:18 GMT

Did Dilip's comment solve things for you? If so, be sure to use the Accept as Solution button on his comment to give him credit... If you are still struggling, here are a couple of links that expand upon his idea:

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Scripting/FormattingFunctions/Dual.htm

https://community.qlik.com/t5/Qlik-Design-Blog/Dual-Exists-Useful-Functions/ba-p/1465290

Regards,
Brett