Qlik Community

QlikView Documents

Documents for QlikView related information.

Slowing changing dimension without using IntervalMatch

MVP & Luminary
MVP & Luminary

Slowing changing dimension without using IntervalMatch

Hi,

Hope below code helps community friends in achieving the slowly changing dimensions without the use of IntervalMatch().  I have a Transaction table with Week and Value fields and I have another table which holds the Rank of a Value in a particular week.  To implement this without using IntervalMatch() we can use below code.

TransactionTable:

Load * Inline [

Week ,Value

10 ,1

10 ,2

10 ,3

10 ,4

11 ,1

11 ,2

11 ,3

11 ,4

];

LEFT JOIN(TransactionTable)

LOAD

Week,

Rank,

Desc,

Start + Iterno() -1 AS Value

WHILE Start + Iterno() -1 < End;

Load *

Inline [

Week ,Start ,End ,Rank ,Desc

10 ,0 ,2 ,1 ,0-2

10 ,2 ,3 ,2 ,2-3

10 ,3 ,6 ,3 ,3-6

10 ,6 ,8 ,4 ,6-8

11 ,0 ,3 ,1 ,0-3

11 ,3 ,4 ,2 ,3-4

11 ,4 ,7 ,3 ,4-7

11 ,7 ,8 ,4 ,7-8

];

Regards,

Jagan.

Version history
Revision #:
1 of 1
Last update:
‎2014-08-22 02:32 AM
Updated by: