Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to display graph data labels in percentage format

Hi All,

I have put up a bar graph with three dimensions and measure is count (member)

Female 1245

Mlae     1254

Unknown 12

For the above data set i have plotted bar graph. But i need the data labels to be in percentage. How should i do it.

17 Replies
micheledenardi
Specialist II
Specialist II

Write your expression and then mark "relative" and "Value on data point" checkbox.

2017-05-26 14_22_36-QlikView x64 Personal Edition - [C__Users_Michele.Denardi_Desktop_test1.qvw_].png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
ahaahaaha
Partner - Master
Partner - Master

May be

Count (member)/Count (Total member)


felipedl
Partner - Specialist III
Partner - Specialist III

Hi Avinash,

See if the attached QVD is what you want.

I used sum instead of count to get the values.

Regards,

Felipe.

trdandamudi
Master II
Master II

Here is one way you can achieve that. Take a look at the attached file:

alis2063
Creator III
Creator III

you would also use percentage as below ,just need to supplied the Dimensions  & Expression,

Anonymous
Not applicable
Author

Hi Michele,

Can you pls explain it in the qliksense ?

Anonymous
Not applicable
Author

Hi Thirumala,

Can you pls explain it with respect to Qliksense.

Regards,

Avinash

vicky_qv
Contributor III
Contributor III

Hi Avinash,

I think you can use measure as Sum(count)/Sum(total count) and in the Number Formatting, you can select 'custom' and format pattern as '#,##0.00%'

Thanks,

Vignesh U.

Anonymous
Not applicable
Author

Hi Vignesh,

Can you pls show it in qliksense.

I hve tried doing but m not getting it.