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: 
Anonymous
Not applicable

Sum over aggr (in text object)

Dear Community,

i have a straight table with one dimension 'Group' and one expression '=SUM(Aggr(SUM(AMOUNT),GROUP))'

On the top are the totals by expression

The result looks like this :

1.png

Now i want to display the total 49398... directly inside a text object as a key performance indicator using the same expression

=SUM(Aggr(SUM(AMOUNT),GROUP)). But its not working as the number is not the same comparing with the straight table total


What i am making wrong? Please help

14 Replies
Anonymous
Not applicable
Author

See attachement below

maxgro
MVP
MVP

maybe

=sum({$ <Group={"*"}>} Amount)

Anonymous
Not applicable
Author

Hi Maxgro,

your solution is not interactive? For example when chossing group A the text object value does not equal with the correct total value of the sraight table. Any idea how to make it possible?

maxgro
MVP
MVP

maybe this

=sum({$ <Group*={"*"}>} Amount)

Anonymous
Not applicable
Author

Best answer till now