Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
hector_jvb
Contributor II
Contributor II

Graph of Bars

I have a graph of bars in which it is necessary to put next to the number between parenthesis the percentage that corresponds that number.

I add graphic image.

Someone who can help me.

Qlik8.png

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

TRy this

For your first expression

= Dual((Count({<Dias_Comprobo={'>10'}>} VIATICANTE) & ' ' & '(' &

     Num(((Count({<Dias_Comprobo={'>10'}>} VIATICANTE))*100)/Num(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)), '#,##0.00')) & ')',

     Count({<Dias_Comprobo={'>10'}>} VIATICANTE))

2nd Expression

=Dual((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE) & ' ' & '(' &

     Num((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)*100)/(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)),'#,##0.00')) & ')',

     Count({<Dias_Comprobo={'<=10'}>} VIATICANTE))

View solution in original post

6 Replies
girirajsinh
Creator III
Creator III

Hi

Pls follow this thread, I guess it would help you

Count in Bar Chart Legend

MarcoWedel

please provide a sample application to demonstrate

thanks

regards

Marco

johnw
Champion III
Champion III

Maybe change your current expression to dual(current expression & '(' & percentage expression & ')',current expression)?

hector_jvb
Contributor II
Contributor II
Author

Hello

Many thanks Girirajsinh Vaghela, Marco Wedel and John Witherspoon for their help.

Use the expression that John suggested and I'm left as I wanted:

Qlik9.png

Can you make the percentage only show me two decimal places?

In addition to the image I added the application.

Greetings.

vishsaggi
Champion III
Champion III

TRy this

For your first expression

= Dual((Count({<Dias_Comprobo={'>10'}>} VIATICANTE) & ' ' & '(' &

     Num(((Count({<Dias_Comprobo={'>10'}>} VIATICANTE))*100)/Num(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)), '#,##0.00')) & ')',

     Count({<Dias_Comprobo={'>10'}>} VIATICANTE))

2nd Expression

=Dual((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE) & ' ' & '(' &

     Num((Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)*100)/(Count({<Dias_Comprobo={'>10'}>} VIATICANTE)+Count({<Dias_Comprobo={'<=10'}>} VIATICANTE)),'#,##0.00')) & ')',

     Count({<Dias_Comprobo={'<=10'}>} VIATICANTE))

hector_jvb
Contributor II
Contributor II
Author

Thank you very much Vishwarath Nagaraju with the two expressions that you provided me and I left the chart as I wanted.

Qlik10.png