topic Re: Sum(Total<>) in QlikView

Sum(Total<>)

Anonymous — Mon, 05 Dec 2016 17:31:19 GMT

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.

swuehl — Mon, 05 Dec 2016 17:34:16 GMT

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 — Mon, 05 Dec 2016 17:55:29 GMT

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 — Mon, 05 Dec 2016 18:03:25 GMT

Try this:

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

Anonymous — Mon, 05 Dec 2016 18:35:05 GMT

Thank you!!!