topic Re: How to add TOTAL into my SET expression ? in QlikView

How to add TOTAL into my SET expression ?

paulyeo11 — Tue, 24 May 2016 04:12:29 GMT

Hi All

I have below 2 expression work fine :-

Sum({<rEVENUE={rEVENUE}>}Amount)

Below is the expression which i want to compute TOTAL for the above expression :-

Sum(TOTAL({<rEVENUE={rEVENUE}>}Amount))

But it deos not work. Can some one advise me why ?

PAul

Chanty4u — Tue, 24 May 2016 04:15:13 GMT

try

=sum(rEVENUE)/sum(Total amount)

tresB — Tue, 24 May 2016 04:20:53 GMT

You have one extra bracket it seems. Try like:

Sum(TOTAL {<rEVENUE={rEVENUE}>} Amount)

ajsjoshua — Tue, 24 May 2016 04:31:24 GMT

Hi,

Try this Sum(ALL {<rEVENUE={rEVENUE}>} Amount).

MayilVahanan — Tue, 24 May 2016 06:13:55 GMT

What is this expression gives

Sum(TOTAL({<rEVENUE={rEVENUE}>}Amount)) ??

rEVENUE is this field??

Are you looking like this??

Sum({<rEVENUE = p(rEVENUE)>}Total Amount)

Sum(Total Amount)

paulyeo11 — Tue, 24 May 2016 06:15:42 GMT

HI chanty

your also work fine. Thank

paulyeo11 — Tue, 24 May 2016 08:21:19 GMT

Hi Sir

Your expression also work fine. Thank you very much .

Paul

Sent from my iPhone