Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Display % and count in Bar Chart

Capture.JPGI 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])
, '#.%')

2 Replies
Highlighted
Partner
Partner

Re: Display % and count in Bar Chart

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))

Capture.PNG

 

 

 

 

 

 

Highlighted
Digital Support
Digital Support

Re: Display % and count in Bar Chart

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/Forma...

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

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.