topic Re: change in the code on date basis in QlikView

change in the code on date basis

Wed, 15 Apr 2015 16:16:35 GMT

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 — Wed, 15 Apr 2015 16:24:40 GMT

Kindly search below in community

IntervalMatch and Slowly Changing Dimensions

Wed, 15 Apr 2015 16:44:52 GMT

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 — Wed, 15 Apr 2015 18:32:39 GMT

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

Thu, 16 Apr 2015 07:33:10 GMT

hi,

i have attached the sample qvw in the post

Thu, 16 Apr 2015 07:33:47 GMT

hi,

i have attached the sample qvw in the post