topic Re: why expression return null value in QlikView

why expression return null value

paulyeo11 — Tue, 13 Aug 2013 21:54:15 GMT

Hi All

i have below expression , but it return null value.

[S_Price]*Currency*sum(Singapore)/sum(BEThailand)

Can some one advise me , how to make it display some value ?

Paul

sushil353 — Tue, 13 Aug 2013 22:45:49 GMT

because,

you are trying to calculate the non aggregated value in a aggregated row..

check this formula .. it should work

sum([S_Price])*Currency*sum(Singapore)/sum(BEThailand)

HTH

Sushil

paulyeo11 — Tue, 13 Aug 2013 22:56:13 GMT

Hi Sushi

Thank you very much , you have good understanding on aggr.