topic Re: Cross qvd With xlsx in QlikView

Cross qvd With xlsx

coddra_6 — Mon, 23 Sep 2013 19:15:31 GMT

Hey!!

What's Up? I want to know How can I cross a dimention (qvd) with a Excel File (xlsx).

I have the case:

Client Dimention:
     Client Code
     Cliente Name
     Cliente Product Code

Excel File:
     Product Code
     Product Name
     Product Risk

And I whant a dimention called Analysis:

Analysis:
     Cliente Code
     Product Code
     Product Risk

But I don't know how to get it.

Hope your help!!

Thanks!!

Re: Cross qvd With xlsx

MayilVahanan — Mon, 23 Sep 2013 20:43:20 GMT

Join with excel and qvd

Try like this

Client:

Load

ClientCode,

ClienteName,

ClienteProductCode

from client.qvd(qvd);

Left join(Client)

Load

ProductCode as [ClienteProductCode],

ProductName,

ProductRisk

From product.xlsx;

Re: Cross qvd With xlsx

Clever_Anjos — Mon, 23 Sep 2013 21:04:39 GMT

"Cliente Product Code" and "Product Code" have the same values (can be a key)?

If so,just rename

LOAD

Product Code as liente Product Code

from yourexcelfile;

AQL will handle the rest

Re: Cross qvd With xlsx

coddra_6 — Mon, 23 Sep 2013 21:45:08 GMT

Yeah, but I need to use:

WHERE Cliente Country = 'Germany'

And the Cliente Country is in the Dimention Cliente.

Re: Cross qvd With xlsx

Oleg_Troyansky — Mon, 23 Sep 2013 22:23:29 GMT

You will need to join the tables first, and then reload using a RESIDENT load, to only filter Clients from Germany.

Re: Cross qvd With xlsx

Tue, 24 Sep 2013 04:54:59 GMT

Hi,

Try like this

Client:

Load

ClientCode,

ClienteName,

ClienteProductCode

from client.qvd(qvd);

Left join(Client)

Load

ProductCode as [ClienteProductCode],

ProductName,

ProductRisk

From product.xlsx;

Analysis:

Load

Cliente Code,

Product Code,

Product Risk,

Resident Client

where dim='dim Value';