topic Re: Help needed while calculating a percentage in a text object field in QlikView

Help needed while calculating a percentage in a text object field

Anonymous — Sat, 10 Mar 2018 14:13:59 GMT

Hello,

I'm trying to calculate a percentage in a text object field.

So far, by using the bellow expression I was able to get the result I want, but it gives me the full % value. But what I really need it a round number with no decimals, or max two decimals numbers.

My values are:

CC: 69

Other: 18

Total (CC + Other) = 87

My expression is:

=count(if([Tipo de contacto]='CC',[Tipo de contacto]))/count([Tipo de contacto])*100 & ' %'

Value gotten so far: 79,310344827586 %

I'm looking for an expression that gives me something like: 79% or 79,31% (with only two decimals)

Many thanks for your help.

Re: Help needed while calculating a percentage in a text object field

jwjackso — Sat, 10 Mar 2018 14:22:35 GMT

You can use the Num function to format the number, below should give you 2 decimal places

Num(count(if([Tipo de contacto]='CC',[Tipo de contacto]))/count([Tipo de contacto])*100,'##0.##')

no decimal places

Num(count(if([Tipo de contacto]='CC',[Tipo de contacto]))/count([Tipo de contacto])*100,'##0')

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/FormattingFunctions/Num.htm

Re: Help needed while calculating a percentage in a text object field

Anonymous — Sat, 10 Mar 2018 14:29:08 GMT

It is correct, it works:

=Num(count(if([Tipo de contacto]='CC',[Tipo de contacto]))/count([Tipo de contacto])*100,'##0,##')& ' %'

This gives the result I want. Many thanks!

Re: Help needed while calculating a percentage in a text object field

sunny_talwar — Sat, 10 Mar 2018 14:31:59 GMT

Also, suggest you to look into set analysis rather than using if statement

=Num(Count({<[Tipo de contacto] = {'CC'}>} [Tipo de contacto])/Count([Tipo de contacto]), '#0.0%')

or this if you want it to be 0 when CC is not selected in Tipo de contacto

=Num(Count({<[Tipo de contacto] *= {'CC'}>} [Tipo de contacto])/Count([Tipo de contacto]), '#0.0%')