Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Specialist
Specialist

Hi,

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

View solution in original post

6 Replies
Chanty4u
MVP
MVP

try

=sum(rEVENUE)/sum(Total amount)

tresesco
MVP
MVP

You have one extra bracket it seems. Try like:

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

ajsjoshua
Specialist
Specialist

Hi,

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

MayilVahanan

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)

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
paulyeo11
Master
Master
Author

HI chanty

your also work fine. Thank

paulyeo11
Master
Master
Author

Hi Sir

Your expression also work fine. Thank you very much .

Paul

Sent from my iPhone