Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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.

1 Reply
marcus_sommer

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

- Marcus