topic Interval match - Sync tables in QlikView

Interval match - Sync tables

qlik_venu — Sat, 07 Apr 2012 09:15:15 GMT

Hi,

i am using interval match to create groups for a Age Column.

Age in years is prsent in the Fact table. I created a intervalmatchtable. and defined the Start and End Age for the Range bukets.

I then used the intervalmatch function to calculate the Range group for the Fact table.

The data is coming fine and i am getting the rows falling into the correct range group.

but when i check the table model, there are sync tables getting created due to this. I would like to keep the model clean and want to remove these sync tables. How to achieve this.

IntervalMatchTable:
LOAD * INLINE [
    AgeGroupSort, AgeGroup , Start , End
    1, Less than 6 months , 0.01 , 0.6
2, 6 months to 1 year , 0.601 , 1
3, 1>3 year    , 1.01 , 3
    4, 3>6 year    , 3.01 , 6
    5, 1>8 year    , 6.01 , 8
    6, 1>10 year   , 8.01 , 10
    7, 1>12 year   , 10.01 , 12
    8, >12 year    , 12.01 , 999
    9,   NA       , 0,0
];

IntervalMatch([Patient Age in years]) Load Start, End Resident IntervalMatchTable;

Interval match - Sync tables

nilesh_gangurde — Sat, 07 Apr 2012 09:30:39 GMT

Heyyy ,

Add the below line in your script, above this line "IntervalMatch([Patient Age in years]) Load Start, End Resident IntervalMatchTable;"

INNER JOIN(IntervalMatchTable)

so your script will be as follows:

INNER JOIN(IntervalMatchTable)

IntervalMatch([Patient Age in years])

Load Start, End Resident IntervalMatchTable;

Regards,

Nilesh Gangurde

Interval match - Sync tables

qlik_venu — Mon, 09 Apr 2012 18:37:26 GMT

Thanks Nilesh, this worked.