Qlik Community

Ask a Question

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

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

View solution in original post

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