Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

paulyeo11
Valued Contributor II

How to add TOTAL into my SET expression ?

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

1 Solution

Accepted Solutions
ajsjoshua
Valued Contributor

Re: How to add TOTAL into my SET expression ?

Hi,

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

6 Replies
Chanty4u
Esteemed Contributor III

Re: How to add TOTAL into my SET expression ?

try

=sum(rEVENUE)/sum(Total amount)

MVP
MVP

Re: How to add TOTAL into my SET expression ?

You have one extra bracket it seems. Try like:

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

ajsjoshua
Valued Contributor

Re: How to add TOTAL into my SET expression ?

Hi,

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

Re: How to add TOTAL into my SET expression ?

HI

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)


or

Sum(Total Amount)

paulyeo11
Valued Contributor II

Re: How to add TOTAL into my SET expression ?

HI chanty

your also work fine. Thank

paulyeo11
Valued Contributor II

Re: How to add TOTAL into my SET expression ?

Hi Sir

Your expression also work fine. Thank you very much .

Paul

Sent from my iPhone

Community Browser