Last year I created qlik view dashboard having multiple reports which is heaving data upto year 2014 .Having joining showed in attached file.
Now the database has been changed so we have created a oracle view for new database in which all the tables columns data is placed (after 2014 year data) in single view.I want to merge this view(new database view) in previous data modeling of qvw file (old database tables). How can i achieve this?
On your new application, you will start to load your QVDs (or load your old application binary file if you prefer), after you will connect to your new database and do for each table a request on your view with only the requested fields.
For dimension tables you will need only to add new entry (use the "exists" function in the where clause).
I have created a view of my new database tables which i need.In this view i have all columns which are in my previous qlikview reports\Data Modeling.So when i merge that view in my previous database modeling then it is creating loop from all tables of my previous database.To avoid this i have remove association from my previous database modeling and join all previous table in single table so that i can merge this final table with my new database view.But the problem is that after join all tables into single table it is showing wrong data.As previous database modeling is created via association not from join.