
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Tags:
- qlikview_scripting
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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...

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try this:
=Aggr(Sum(TOTAL <Segment> [Amont Sales]), Product, Segment)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you!!!
