Skip to main content
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.