Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Facing Problem in script with Record filtering


Hi,

I have a requirement to fetch data from DB with multiple condition.I need the records with Flag='Y' and 'N' as well and for Flag=N, only Max(MD_DATE) is required.

1) I need to Fetch FIRST_NAME, LAST_NAME, CITY, ZIP_CODE, CUSTOMER_ID, MANUAL_FLAG, DB_ACTIVE_FLAG

from the DB WHERE (DB_ACTIVE_FLAG='Y' OR  DB_ACTIVE_FLAG='N') AND MANUAL_FLAG='Y' (Max(MD_DATE);

Could anyone help me on this?

Thanks in advance.

Tags (3)
1 Reply
hrlinder
Honored Contributor

Re: Facing Problem in script with Record filtering

I would suggest a two step load:

1) load from database with the first condition

2) concatenate load with the second condition

In this scenario you cantest the two loads separately and you do not need to know exactly the syntax

of the combined condition!

Community Browser