Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikvw2019
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
dplr-rn
Partner - Master III
Partner - Master III

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

 

 

 

 

 

 

Brett_Bleess
Former Employee
Former Employee

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.