# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for
Did you mean:
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.

Someone who can help me.

1 Solution

Accepted Solutions
Champion III

TRy this

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

6 Replies
Creator III

Hi

MVP

please provide a sample application to demonstrate

thanks

regards

Marco

MVP

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

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:

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

Greetings.

Champion III

TRy this

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

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.