Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Table join and group query

I have 3 database tables.


Key     DataOne

1          A

2          B


Key     DataTwo

1          10

1          15

2          20


Key     DataThree

1          50

1          60

2          200

2          210

How to obtain a report as below.

DataOne     SumOfDataTwo     SumOfDataThree     SumOfDataThreeMinusSumOfDataTwo

A                    25                              110                                             85

B                    20                              410                                             390

Tags (4)
1 Reply

Table join and group query


   Create a straight chart.

   Include Dataone as Dimension.

   Expression as Sum(DataTwo) For SumOfDataTwo

   Sum(DataThree) for SumOfDataThree

   Sum(DataThree) -  sum(DataTwo)


   Column(2)- Column(1)


Kaushik Solanki

Community Browser