topic Re: combining the data from different sources in QlikView

combining the data from different sources

Thu, 17 Dec 2015 10:30:29 GMT

Hi Friends,

i am having two months of data as my source(xls)..i want to show two months data in my chart in two columns.

here my problem is every month data comes from three excels.

for example, if i want to show November data i have to consider

Nov_IR dump,

Nov_FX dump,

Nov_COA dump, same for December also.

three dumps are having different data, but fields will be same in the two months data.

if i will concatenate i am getting data for two months in different different charts...

if i want to show the two months data in a single chart, what i have to do?

please help me..

sorry i am not able to upload the qvw ...

Thanks,

Sowmya

Re: combining the data from different sources

avinashelite — Thu, 17 Dec 2015 10:34:21 GMT

could you please share the sample data ?? it will help us to understand the data

Re: combining the data from different sources

Anonymous — Thu, 17 Dec 2015 10:36:02 GMT

Fields/Column name in

Nov_IR dump,

Nov_FX dump,

Nov_COA dump is same???

If yes, did you try like this,

Final_Data:

load *

'Nov' as Flag

from Nov*;

//For Dec

Load

'Dec' as Flag

from Dec*;

If you do like this, hope you will be able to achieve what you are looking for..

Re: combining the data from different sources

Chanty4u — Thu, 17 Dec 2015 10:36:18 GMT

try to do inner join

Re: combining the data from different sources

Anonymous — Thu, 17 Dec 2015 10:36:55 GMT

two months in different different chart means?

share a snapshot of that..

Re: combining the data from different sources

Chanty4u — Thu, 17 Dec 2015 10:38:07 GMT

or Qualify use

Re: combining the data from different sources

PradeepReddy — Thu, 17 Dec 2015 11:13:03 GMT

Please post the sample data..

Re: combining the data from different sources

Fri, 18 Dec 2015 02:36:53 GMT

Hi,

i am having the source and data as below...

Dec4:	Dec11:
LOAD DataDate,	LOAD DataDate,
date(DataDate,'DD/MM/YYYY')as Date,	date(DataDate,'DD/MM/YYYY')as Date,
Portfolio,	Portfolio,
Nett,	Nett,
FROM	FROM

LOAD	LOAD
Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,	Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,
Quotation,	Quotation,
Bid,	Bid,
Ask,	Ask,
Mid	Mid
FROM	FROM

COA:	COA:
LOAD [Stratification Audit],	LOAD [Stratification Audit],
If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,	If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,
H as Currency,	H as Currency,
I as FaceAmount,	I as FaceAmount,

FROM	FROM

i want to show these two dates data in two columns in my chart? how i can?

thanks...

Re: combining the data from different sources

Fri, 18 Dec 2015 02:41:33 GMT

Hi,

i am having the source and data as below...

Dec4:	Dec11:
LOAD DataDate,	LOAD DataDate,
date(DataDate,'DD/MM/YYYY')as Date,	date(DataDate,'DD/MM/YYYY')as Date,
Portfolio,	Portfolio,
Nett,	Nett,
FROM	FROM

LOAD	LOAD
Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,	Date( Date#(Date,'YYYYDDMM'),'MM/DD/YYYY') as Date,
Quotation,	Quotation,
Bid,	Bid,
Ask,	Ask,
Mid	Mid
FROM	FROM

COA:	COA:
LOAD [Stratification Audit],	LOAD [Stratification Audit],
If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,	If(len(trim(E))>0, E,If(len(trim(E))=0,If(len(trim(D))>0, D,If(len(trim(D))=0,peek('COA'),If(len(trim(C))>0,C)))))as COA,
H as Currency,	H as Currency,
I as FaceAmount,	I as FaceAmount,

FROM	FROM

i want to show these two dates data in two columns in my chart? how i can?

thanks...

Re: combining the data from different sources

Fri, 18 Dec 2015 02:43:01 GMT

I can able to crate two charts using Qualify as suresh told....

but i want show these two dates data into single chart..

please help me

Re: combining the data from different sources

Fri, 18 Dec 2015 06:51:59 GMT

Any Idea?

Re: combining the data from different sources

PradeepReddy — Fri, 18 Dec 2015 07:03:07 GMT

Concatenate the 2 tables, by adding one column with month name which you can take it from input file.

In charts,

out of 2 dimensions one should be month and other would be your requirement.

consider one expression.

if still not satisfied with the result, post the sample output that you are looking for?

Re: combining the data from different sources

Fri, 18 Dec 2015 07:43:50 GMT

Hi Pradeer,

thank you for the reply,

for each date i will get data from the three dumps.

fields are same but data will be different..

here one more problem i can't concatenate the third dump with other two also, because of it do not have date field and one more thing is in dump1 also currency field is there so it will combine with that and will give wrong result.

here i am having two dates, i am creating charts for individual dates.

please find the attachments