Self join Sql to Qlikview

[kkkumar82]

Hi All,

Below is the part of a SQL query which I am trying to do it in Qlikview, in this      

                          Select .....

                                   From

                                   mrp.mrp_forecast_dates dates,

                                   holx.holx_gl_month_v mos,

                                   holx.holx_gl_month_v mos2,

                                   holx.holx_gl_month_v mos3,

                                   holx.holx_gl_month_v mos4,

                                   holx.holx_gl_month_v mos5,

                                   holx.holx_gl_month_v mos6,

                                   holx.holx_gl_month_v mos7

                             WHERE dates.forecast_designator IS NOT NULL                                  

                                   AND dates.forecast_date >= mos.start_date

                                   AND dates.rate_end_date IS NULL

                                   AND mos.start_date <= TRUNC (SYSDATE)

                                   AND mos.end_date >= TRUNC (SYSDATE)

                                   AND mos.seq = mos2.seq - 1

                                   AND mos.seq = mos3.seq - 2

                                   AND mos.seq = mos4.seq - 3

                                   AND mos.seq = mos5.seq - 4

                                   AND mos.seq = mos6.seq - 5

                                   AND mos.seq = mos7.seq - 6

If you observe dates, holx.holx_gl_month_v are the only two tables used.

How can we mimic in Qlik

[sunny_talwar]

May be do that using Qualify

Qualify *;

Unqualify FieldNames based on your WhereStatement

T1:

LOAD *

FROM Source1;

LEFT Join (T1)

LOAD *

FROM Source1;

...

One thing that seems to be easily understandable is this;

Qualify *;

Unqualify seq (FieldNames based on your WhereStatement)

T1:

LOAD seq,

           OtherFields

FROM Source1;

LEFT Join (T1)

LOAD seq - 1 as seq,

          OtherFields

FROM Source1;

...