topic Re: Load data from QVD with multiple conditions in QlikView

Load data from QVD with multiple conditions

vikasmahajan — Wed, 28 Oct 2015 04:46:26 GMT

Dear All,

I have following 3 tables in qvd

MARS:

Host_Name,

from Mars.QVD (qvd);

TAMS:

Host_Name,

Product_Type,

...

ApplicationID

from TAMS.QVD (qvd);

SEAL:

Application ID

...

From SEAL.QVD (qvd);

I want to join this qvds with condition AppicationID='Operating System' there are so many conditions like application id.

In this scenario what I have to do ?

Please share idea ?

Thanks in adv.

Vikas

Re: Load data from QVD with multiple conditions

_rohitgharat — Wed, 28 Oct 2015 04:49:37 GMT

Dear Vikas,

First of all load all three tables seperately using where condition (i.e AppicationID='Operating System' ) and then join them. I hope it will work

Regards,

Rohit

Re: Load data from QVD with multiple conditions

kumarnatarajan — Wed, 28 Oct 2015 04:59:35 GMT

Hi Vikas,

See the below example it may help you.

Ex:

SEAL:

Application ID

...

From SEAL.QVD (qvd)

where wildmatch(AppicationID,"Operating System","Operating*");

Left Join(SEAL)

TAMS:

Load

AppicationID,

......,

from TAMS.QVD (qvd);

Left Join(SEAL)

MARS:

Host_Name,

from Mars.QVD (qvd);

Re: Load data from QVD with multiple conditions

PradeepReddy — Wed, 28 Oct 2015 05:05:32 GMT

all conditions in same table or in different tables?

Can you please elaborate the problem?

Re: Load data from QVD with multiple conditions

vikasmahajan — Wed, 28 Oct 2015 05:21:17 GMT

for each table conditions are different like wildmatch(AppicationID,"Operating System","Operating*"); for SEAL.

Re: Load data from QVD with multiple conditions

PradeepReddy — Wed, 28 Oct 2015 05:35:53 GMT

TAMS:

Host_Name,

Product_Type,

...

ApplicationID

from TAMS.QVD (qvd)

where condition1 and condition2;

Left join(TAMS):

Host_Name,

...

from Mars.QVD (qvd)

where condition3 and condition4;

Left join(TAMS)

SEAL:

Application ID

...

From SEAL.QVD (qvd)

where condition5 and condition6;

Other way is...

during the data extraction from DB only, apply all these filters in SQL query. Then perform the necessary operation in qlikview.

Re: Load data from QVD with multiple conditions

vikasmahajan — Wed, 28 Oct 2015 05:44:27 GMT

thanks i will apply the same

Re: Load data from QVD with multiple conditions

vikasmahajan — Thu, 29 Oct 2015 04:37:14 GMT

it's fixed thanks

vikas