Data Model

[upaliwije]

Hi

I have following data in 3 tables

Tbl 1

CLNO  INT_DATE  REG_DATE  AMOUNT

125     01-01-15     20-01-15      1000

130     31-01-15     02-02-15       2000

Tbl2

CLNO  PRO_DATE     PRV_AMT

125     20-01-15          1000

125     02-02-15           2000

125     03-03-15           1000

130     02-02-15            2000

130     28-02-15           1000

Tbl3

CLNO  PD_DATE      PD_AMT

125     25-01-15        1000

125      03-03-15        2000

130    05-02-15          1500

130    05-04-15           1000

I want create a QV document  and to create a Pivot table in the following format

INT_MONTH   REG-MONTH  PRO_MONTH   PD_MONTH   NOS  AMOUNT  PRV_AMT  PD_AMT

  JAN-15          JAN-15         JAN-15            JAN-15           2       3000      1000          1000

                       FEB-15         FEB-15             FEB-15         1                     5000          1500

                                           MAR-15             MAR-15                               1000          2000

                                                                    APR-15                                                 1000

Pls help me

[#2]

Hi,

You can load the 3 tables to Qlikview. It will be joined based on CLNO. Then you can pull the fields to pivot table dimensions. To extract month from date, use Date function.

[Anonymous]

Hi Upali,

Please what's the logic behind column NOs.

Regards

Neetha