topic Calculating a percentage using expressions in QlikView

Calculating a percentage using expressions

Fri, 12 Nov 2010 22:37:56 GMT

Hi,

I have a straight table that has the following expressions:

1Link Advances

Advances Offline

Total Advances

I am trying to show what percentage of Advances are 1Link Advances. I tried creating an additional expression

=sum ('1Link Advances')/sum('Total Advances')*100

with no luck. Can you not reference an existing expression inside another expression? I think what I'm trying to do should be pretty simple but I'm not sure of the syntax.

Any help would be greatly appreciated.

Thanks,

Shannon

Calculating a percentage using expressions

pover — Fri, 12 Nov 2010 23:04:47 GMT

You can refer to another column, but you don't put it in sum(). It should be like the following:

[1Link Advances]/sum([Total Advances])

And instead of multiplying by 100, just tick the show in percentage (%) in the Number tab.

Regards.

Calculating a percentage using expressions

johnw — Sat, 13 Nov 2010 00:16:47 GMT

Yes, you can reference an existing expression inside another, either by name or by column number:

"1Link Advances"/"Total Advances"
column(1)/column(3)

As Karl says, use the number tab to display as percentage rather than multiplying by 100.