topic Re: add percentage in QlikView

add percentage

soniasweety — Fri, 15 Nov 2024 23:39:16 GMT

Hi all,

I have a column avg score with values like

AvgScore( in percentage)

based on this column I want to get the new column if avg score is <60% fail else pass.

and I want to add % to above column how to add...

Taoufiq_Zarra — Tue, 10 Nov 2020 15:32:55 GMT

@soniasweety if I understood correctly to add pourcentage you can use for example

Num(YOURAVGFORMULA,'#0%')

and for fail and pass you can for example use

if(YOURAVGFORMULA<60,'fail','pass')

soniasweety — Tue, 10 Nov 2020 15:38:32 GMT

Hi,
if I use this Num(YOURAVGFORMULA,'#0%') im getting result values is 4500% 5500% like that ..

MayilVahanan — Wed, 11 Nov 2020 02:33:13 GMT

Hi @soniasweety

Try like below

Num(YOURAVGFORMULA /100,'#0%')
and

if(YOURAVGFORMULA<60,'fail','pass')
or if(YOURAVGFORMULA/100<0.60,'fail','pass')