topic Re: Calculat Percentage in a Chart Expression in QlikView

Calculat Percentage in a Chart Expression

alec1982 — Tue, 18 Sep 2012 20:47:46 GMT

hi guys,

I have a field as follow:

Broker

ABC

XYZ

ARS

XYZ

ABC

I need to build a chart to show the percentage of that field to total nr.

Like Perecentage of ABC= 4*100/7= 57.14

If I add the field broker as dimenssion and then Expression as Count(Broker)*100/Count({1}Broker) I get 100% each.

Any solution.

Thxs,

MayilVahanan — Tue, 18 Sep 2012 20:53:30 GMT

Try like this

=Count(Broker)*100/Count({1} total Broker)

Hope that helps

alec1982 — Tue, 18 Sep 2012 20:55:41 GMT

Thxs!

alec1982 — Tue, 18 Sep 2012 21:02:21 GMT

Sorry to inturppt you again, but still have one more thing:

how can i format the number to show the % next to it.

Thxs

v_iyyappan — Tue, 18 Sep 2012 21:11:17 GMT

Hi,

referred the below image its help for u.

Iyyappan.

MayilVahanan — Tue, 18 Sep 2012 21:13:40 GMT

Use Something like this

Num((Count(Broker)*100/Count({1}total Broker))/100,'##0.0%')

Hope it helps