Result set to a straight table

[Anonymous]

I have three tables

A

date                    Product     type     sales

  1/20/2016             A               1          100

2/12/2016               B               2          100

1/21/2016               C               c          120

B

Product     desc

A               aaa

B               bbb

C               ccc

C

Type     desc

1          Aab

2          Bbc

3          Ccd

want the result of the below sql in a straight table.

select A.date , b.desc, c.desc, sum(sales) where a.product=b.product

and a.type=c.type

and a.date between '1/2/2016' to '5/12/2016'

group by A.date , b.desc, c.desc

Have loaded the table A,B, C into Qlikview . Added the straight table in and dimension been added. Now the expression to be added as Sum(sales)  but that does not give the result. how to add the group by clause in the expression.

[marcus_sommer]

Use a pivot-chart instead of the straight-table and enable partial-sums (tab presentation) on the product-dimension.

- Marcus