Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vardhancse
Specialist III
Specialist III

Change in dim (SCD)

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

3 Replies
vardhancse
Specialist III
Specialist III
Author

can some one help me out to achieve my requirement.

sunny_talwar

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?

arjakumar
Contributor III
Contributor III

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.