Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Write your expression and then mark "relative" and "Value on data point" checkbox.
May be
Count (member)/Count (Total member)
Hi Avinash,
See if the attached QVD is what you want.
I used sum instead of count to get the values.
Regards,
Felipe.
Here is one way you can achieve that. Take a look at the attached file:
you would also use percentage as below ,just need to supplied the Dimensions & Expression,
Hi Michele,
Can you pls explain it in the qliksense ?
Hi Thirumala,
Can you pls explain it with respect to Qliksense.
Regards,
Avinash
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.
Hi Vignesh,
Can you pls show it in qliksense.
I hve tried doing but m not getting it.