topic how to show data from diff sources together in QlikView https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627847#M230670 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two data sources</P><P> excel sheet , database QVD</P><P></P><P>now I'm using graph dat only shows number&nbsp; as total sale .</P><P></P><P></P><P>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.</P><P></P><P>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.</P></BODY></HTML> Mon, 26 May 2014 10:13:03 GMT 2014-05-26T10:13:03Z how to show data from diff sources together https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627847#M230670 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two data sources</P><P> excel sheet , database QVD</P><P></P><P>now I'm using graph dat only shows number&nbsp; as total sale .</P><P></P><P></P><P>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.</P><P></P><P>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.</P></BODY></HTML> Mon, 26 May 2014 10:13:03 GMT https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627847#M230670 2014-05-26T10:13:03Z Re: how to show data from diff sources together https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627848#M230671 <HTML><HEAD></HEAD><BODY><P>You need to load both qvd and excel file in your data model and connect the sources by fieldnames</P><P> Then you can automatically find</P></BODY></HTML> Mon, 26 May 2014 10:15:06 GMT https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627848#M230671 Anonymous 2014-05-26T10:15:06Z Re: how to show data from diff sources together https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627849#M230672 <HTML><HEAD></HEAD><BODY><P>PFA sample application for study. </P><P></P><P></P><P></P><P>Vikas</P></BODY></HTML> Mon, 26 May 2014 10:42:05 GMT https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627849#M230672 vikasmahajan 2014-05-26T10:42:05Z Re: how to show data from diff sources together https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627850#M230673 <HTML><HEAD></HEAD><BODY><P>You should most likely concatenate similar tables from the two sources. Read this also:</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/14/merging-data" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/14/merging-data">http://community.qlik.com/blogs/qlikviewdesignblog/2014/01/14/merging-data</A></P><P></P><P>HIC</P></BODY></HTML> Mon, 26 May 2014 19:38:38 GMT https://community.qlik.com/t5/QlikView/how-to-show-data-from-diff-sources-together/m-p/627850#M230673 hic 2014-05-26T19:38:38Z