2 or more data source

[#1]

Is it possible to have a chart made up from more tahn 1 data source

[#2 · Accepted solution]

Hi Advayaa,

It is possible to have more than once datasource in the Single chart.

[#3]

Yep this is also one of the numerous advantages of QlikView.

You can merge, or compare, or mix differents datasources ( 1, 2, 3, etc..) and use them as you want and where you want in the charts !

Rgds,

Sébastien

[#4]

How do we achieve this

please describe

[marcohadiyanto]

hi,

it's possible to have a chart made up from many data source.

just Load into qvw. 🙂

[suniljain]

In Chart you can display data from all sources that you covered in data modelling.

there is no limitation on that part.

[johnw]

advayaaa wrote:How do we achieve this
please describe

When you create a chart, it will give you a list of fields you can use as dimensions. These are all the fields, not fields from a specific data source, unless you ASK it to only show you fields from one data source. Similarly, when adding expressions, you can reference any field, regardless of data source. In other words, you use fields from multiple data sources the exact same way as you use fields from one data source. QlikView doesn't care. There is nothing special required. If you can build the most basic of QlikView charts, you already know how to use fields from multiple data sources.

[#8]

My main issue is how to get two data sources together. I am using an excel sheet as a data source. It has two worksheets . whenever I Create a new qvw file it asks for the source and it is taking the 1st sheet as the data source by default and not including the 2nd data sheet. Please tell me easy and simple steps to achieve this

[suniljain]

You can use multi data source in single QVW but there should be link between multi data source otherwise its not possible.

[#10]

How to do that, plz give steps, and if we need to edit the script plz tell me how to do that