Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
Document boards are being consolidated, this board no longer allows NEW documents READ MORE

Slowing changing dimension without using IntervalMatch

cancel
Showing results for 
Search instead for 
Did you mean: 
jagan
Luminary Alumni
Luminary Alumni

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
Last update:
‎2014-08-22 02:32 AM
Updated by: