Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum(Total<>)

Hi guys.

Hlep me with somethig, for example:

I have some products...
 

  Product               Segment          Amont Sales

  Heineken              Beer                10

  Budweiser             Beer                20  

  Blue Label            whisky              30

  Jack Daniels         whisky              40

If i make :

Product               Segment          Amont_Sales          Sum( Total Amont_Sales)

  Heineken              Beer                10                         100

  Budweiser             Beer                20                         100   

  Blue Label            whisky              30                         100

  Jack Daniels         whisky              40                         100


Right?


But i dont wanna TOTAL , i want TOTAL by Segment,  in the other words, the table must be like this:


Product               Segment          Amont_Sales          Sum( Total <Segmente> Amont_Sales)

  Heineken              Beer                10                         30

  Budweiser             Beer                20                         30

  Blue Label            whisky              30                         70

  Jack Daniels         whisky              40                         70



But "Sum( Total <Segmente> Amont_Sales)" not its worked in my example...


Someone knows how i do that?


Thank you.


1 Solution

Accepted Solutions
sunny_talwar

Try this:

=Aggr(Sum(TOTAL <Segment> [Amont Sales]), Product, Segment)

View solution in original post

4 Replies
swuehl
MVP
MVP

Create a straight table chart with two dimensions, using Product and Segment field.

Then create two expressions

=Sum(Amont_Sales)

=Sum(TOTAL<Segment> Amont_Sales)

Segment should be the field you are using as dimension.

Anonymous
Not applicable
Author

I got it...Really works...but to my solicitation i must have only Product as dimension...

You know another way to make this?...
I forgot to warn, but i am in qliksense..=/

If not have solution, no problem...=D

Thanks anyway...

sunny_talwar

Try this:

=Aggr(Sum(TOTAL <Segment> [Amont Sales]), Product, Segment)

Anonymous
Not applicable
Author

Thank you!!!