topic Re: Change in dim (SCD) in QlikView

Change in dim (SCD)

vardhancse — Wed, 28 Mar 2018 10:06:55 GMT

Hi,

I have one requirement, having ID and based on that need to stamp dept name.

Using mapping table and applymap done. but now the problem is that now there is change in dept name for the existing ID.

So based on month and year filter old and new name should be displayed in my chart / table.

PFA sample app created

Re: Change in dim (SCD)

vardhancse — Thu, 29 Mar 2018 10:29:21 GMT

can some one help me out to achieve my requirement.

Re: Change in dim (SCD)

sunny_talwar — Thu, 29 Mar 2018 11:23:42 GMT

I am not sure how the attached qvw is linked to the SCD? Can you elaborate with an example from your qvw as to what you are looking to get to?

Re: Change in dim (SCD)

arjakumar — Thu, 29 Mar 2018 11:28:01 GMT

Hi Sasi,

Using interval match we can do this mapping. Could you please paste your tables with fields, then we can say it is feasible to apply interval match or not.