Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sum of amont

Hello.

Can i have help please. I want to have in the Text Object the total amont of AG12 and AG10.

In fact  the amont of

AG12=50000

and

AG10=40000

so the total amont (AG12+AG10)=90000.

How can i do that.

Best regards.

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

=Sum(Aggr(DISTINCT AMONT_LIGN_BUD,CODE_LIGN_BUD))

View solution in original post

5 Replies
anbu1984
Master III
Master III

=Sum(Aggr(DISTINCT AMONT_LIGN_BUD,CODE_LIGN_BUD))

Not applicable
Author

Hello.

Think you. It work nomaly with your code.

Best regards!

anbu1984
Master III
Master III

If you don't have any further queries, please close the thread as answered

Anonymous
Not applicable
Author

Hi Destin,

Try this:

=sum( {< CODE_LIGN_BUD = {GA10,GA12}>} distinct AMONT_LIGN_BUD)

Nitha

Not applicable
Author

Hello

Think you. I will try also your code. In fact anbu1984 give me a right code.

Best regards!