Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
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.

TableOne

Key     DataOne

1          A

2          B

TableTwo

Key     DataTwo

1          10

1          15

2          20

TableThree

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

Hi,

   Create a straight chart.

   Include Dataone as Dimension.

   Expression as Sum(DataTwo) For SumOfDataTwo

   Sum(DataThree) for SumOfDataThree

   Sum(DataThree) -  sum(DataTwo)

                    Or

   Column(2)- Column(1)

Regards,

Kaushik Solanki

Community Browser