# QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
New 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.

Tags (1)
1 Solution

Accepted Solutions
Esteemed Contributor III

## Re: Graph of Bars

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
Contributor III

Hi

MVP

## Re: Graph of Bars

please provide a sample application to demonstrate

thanks

regards

Marco

MVP

## Re: Graph of Bars

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

New Contributor II

## Re: Graph of Bars

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.

Esteemed Contributor III

## Re: Graph of Bars

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

New Contributor II

## Re: Graph of Bars

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