get records from qvd

Tue, 02 Dec 2014 10:34:28 GMT

Hi Folks,

I have a situation here:

I have set of orders for different cities. Each order has three status complete, draft and void. The data exists in the qvd.

Now for all cities I wish to get the orders in status complete but for only for 1 city say Delhi I wish to get the orders in status complete and draft both.

How do i get this done?

Help much appreciated.

Thank you.

Re: get records from qvd

its_anandrjs — Tue, 02 Dec 2014 10:42:34 GMT

Hi,

Try to create the resident table to get the data in order status complete, draft and void

Source:

Load

Orders,

City,

status

From Source;

Noconcatenate

Load

Orders,

City,

status

From Source

Order By Match(status,'complete', 'draft','void');

Drop table Source;

Source:

Load

Orders,

City,

status

From Source;

Noconcatenate

Load Orders,City,status

From Source where Match(status,'complete');

Concatenate

Load Orders,City,status

From Source where Match(status, 'draft');

Concatenate

Load Orders,City,status

From Source where Match(status,'void');

Drop table Source;

Regards

Anand

topic get records from qvd in QlikView

get records from qvd

Re: get records from qvd