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.
