how to show data from diff sources together - Qlik Community

Report Inappropriate Content · ‎2014-05-26

Hi,

I have two data sources

excel sheet , database QVD

now I'm using graph dat only shows number as total sale .

and for the year 13-14 i have used excel sheet as data source and for the year 14-15 I'm using database as datasource.

so i want to show them together like if user select year 13-14 it will show that excel data and year 14-15 it will show data from another source.

Anonymous · ‎2014-05-26

You need to load both qvd and excel file in your data model and connect the sources by fieldnames

Then you can automatically find

vikasmahajan · ‎2014-05-26

PFA sample application for study.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

hic · ‎2014-05-26

You should most likely concatenate similar tables from the two sources. Read this also:

http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/14/merging-data

HIC