topic where clause from qvd in QlikView

where clause from qvd

Tue, 21 Dec 2010 06:32:56 GMT

i want to use where clause from my qvd.

please let me know what is wrong in my script.

please find the attached qvd file.

where clause from qvd

Tue, 21 Dec 2010 06:36:03 GMT

Can you send the where clause script which you are trying to apply.

where clause from qvd

Tue, 21 Dec 2010 06:40:47 GMT

Hi abcd1234,

If you are trying to use a where clause when extracting data from a qvd then the syntax will be something like the following:

LOAD EVENT_DATE,
 AOC_SHOWED,
 AOC_REJECTED,
 AOC_OK,
 PURCHASE_FAILURE,
 PURCHASE_REVENUE,
 RENEWAL_REVENUE,
 PREMIUM_COUNT,
 CANCEL_COUNT,
 PURCHASE_COUNT,
 RENEWAL_COUNT,
 CONTENT_ID,
 CONTENT_PROFILE_ID,
 CONTENT_PROVIDER_ID,
 CHARGING_PROFILE_TYPE_ID,
 CONTENT_NAME,
 ACCOUNT_TYPE
FROM
SUMMARY.qvd
(qvd)
WHERE ACCOUNT_TYPE=2;

I hope this helps.

Rod

where clause from qvd

Tue, 21 Dec 2010 06:47:34 GMT

Hi,

It is working fine for me.

Please check.