topic Re: changes with respect to date in QlikView

changes with respect to date

Tue, 14 Apr 2015 14:20:58 GMT

Hi Experts,

i have a table with some branches & their corresponding branch codes.

the branch called Dundee and its branch code changed from 003 to 030.

the changes effect from march 23, 2015.

from jan 2015 to march 23, 2015 the branch code is 003.

i have another table which contains the working days for all branches & also table for sales & targets.

i got a pivot table which shows the targets & actual sales of all branches.

the targets have some calculations which depends on the working days of a particular branch.

if i select, jan 2015 or feb 2015, the working days have to pick up for the branch code 003

if i select march 2015, the working days have to pick up for the branch code 003 & 030(it should give the added value)

and if i select april 2015 and for the remaining months, the working days have to pick up for the branch code 030.

how can i do this.

please help in this regard.

Re: changes with respect to date

morganaaron — Tue, 14 Apr 2015 15:07:13 GMT

Slowly Changing Dimensions sounds like what you're talking about. It'll all depend on what history you hold on your data, and how you want to attach this.

Re: changes with respect to date

ramoncova06 — Tue, 14 Apr 2015 15:09:21 GMT

use interval match IntervalMatch, this will create an entry for in between period

Re: changes with respect to date

Tue, 14 Apr 2015 15:24:41 GMT

hi,

thanks for your reply.

can u please help me with the script

Re: changes with respect to date

Tue, 14 Apr 2015 15:25:13 GMT

hi,

thanks for your reply.

can u please help me with the script

Re: changes with respect to date

morganaaron — Wed, 15 Apr 2015 07:21:03 GMT

There's a technical guide at the bottom of that article that should give you a head start - give it a try first, happy to help if you run into issues along the way!