topic Re: How to display graph data labels in percentage format in QlikView

How to display graph data labels in percentage format

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: How to display graph data labels in percentage format

micheledenardi — Fri, 26 May 2017 12:23:51 GMT

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

Re: How to display graph data labels in percentage format

ahaahaaha — Fri, 26 May 2017 12:25:47 GMT

May be

Count (member)/Count (Total member)

Re: How to display graph data labels in percentage format

felipedl — Fri, 26 May 2017 12:26:36 GMT

Hi Avinash,

See if the attached QVD is what you want.

I used sum instead of count to get the values.

Regards,

Felipe.

Re: How to display graph data labels in percentage format

trdandamudi — Fri, 26 May 2017 12:34:58 GMT

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

Re: How to display graph data labels in percentage format

alis2063 — Fri, 26 May 2017 12:50:00 GMT

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

Re: How to display graph data labels in percentage format

Anonymous — Mon, 29 May 2017 07:11:12 GMT

Hi Michele,

Can you pls explain it in the qliksense ?

Re: How to display graph data labels in percentage format

Anonymous — Mon, 29 May 2017 07:18:06 GMT

Hi Thirumala,

Can you pls explain it with respect to Qliksense.

Regards,

Avinash

Re: How to display graph data labels in percentage format

vicky_qv — Mon, 29 May 2017 08:15:11 GMT

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.

Re: How to display graph data labels in percentage format

Anonymous — Mon, 29 May 2017 11:37:06 GMT

Hi Vignesh,

Can you pls show it in qliksense.

I hve tried doing but m not getting it.

Re: How to display graph data labels in percentage format

trdandamudi — Mon, 29 May 2017 12:01:47 GMT

Sorry, I am not into QlikSense,, Hope someone will help you out,,,

Re: How to display graph data labels in percentage format

vicky_qv — Mon, 29 May 2017 12:17:41 GMT

Hi,

Please find here.

Thanks,

Vignesh U.

Re: How to display graph data labels in percentage format

kkkumar82 — Mon, 29 May 2017 12:25:00 GMT

Hi,

I have tried with a simple inline load of your data

Re: How to display graph data labels in percentage format

kkkumar82 — Mon, 29 May 2017 12:25:31 GMT

Is this what you want

Re: How to display graph data labels in percentage format

Anonymous — Mon, 29 May 2017 12:31:47 GMT

Hi Kiran,

Exactly this is what i wanted. Can you share the screenshots of measure you used

Regards,

Avinash

Re: How to display graph data labels in percentage format

vicky_qv — Mon, 29 May 2017 13:18:11 GMT

Hi Avinash,

Is the expression (Sum(count)/Sum(total count)) not working as measure for you?

Thanks,

Vignesh U.

Re: How to display graph data labels in percentage format

kkkumar82 — Mon, 29 May 2017 13:45:41 GMT

I have used an Inline load, taking

Gender, Count

as columns and in the expression I have used

Sum(Count)/Sum(total Count) and change the format to Number and Select the one which is showing percentage with 2 decimal points.

Re: How to display graph data labels in percentage format

kkkumar82 — Mon, 29 May 2017 13:46:45 GMT

Let me know the expression how your are calculating the count so that we can say the expressions for your scenario