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


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Use a pivot-chart instead of the straight-table and enable partial-sums (tab presentation) on the product-dimension.
- Marcus
