change in the code on date basis

[#1]

hi experts,

i have attached the sample qvw file.

i have a pivot table which has some expressions based on some calculations.

the calculations depends on the branch and the working days.

this working days get varied according to the branch.

the branch name called dundee has two codes 0831 & 0201.

from jan 2015 to march 23, 2015, the branch code for dundee is 0831 and after march 23, 2015, the branch code for dundee is 0201.

i have a month & date list boxes. if i select on jan2015 or feb 2015, the calculations for dundee branch should go with the code 0831

if i select on march 2015, the calculations for dundee branch should go with the code 0831 and 0201 (should get added up).

if i select on april 2015 or later, the calculations for dundee branch should go with the code 0201.

how can i do this in scripting or....

please help me in this regard.

[MK_QSL]

Kindly search below in community

IntervalMatch and Slowly Changing Dimensions

[#3]

hi,

thanks for the reply,

can you please help me with the script.

i have tried interval match but not sure about SCDs

[MK_QSL]

Kindly provide sample data then only I can work on your question...

[#5]

hi,

i have attached the sample qvw in the post

[#6]

hi,

i have attached the sample qvw in the post