Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Not applicable

Load data only if a criteria is met

I am trying to do the following :

load accounts that have a  type "Headquarters"  as Parent Account. I want to do this when data is loaded.

Note data is coming from salesforce.

Is this possible to do in the edit script?

4 Replies
thomas_skariah
Contributor III

Re: Load data only if a criteria is met

Hi Victor,

The application must reload only when account type is 'headquarters'?

Otherwise no need to reload.Is it right.

Regards,

Tom

Not applicable

Re: Load data only if a criteria is met

Almost.  The account will always reload. What i would like to happen is that when it loads the Accounts, to take all the accounts that have an account type of "Headquarters" to load in a dimension called Parent Account.

Hope I explained it.

thomas_skariah
Contributor III

Re: Load data only if a criteria is met

Hi Victor,

Sorry if i didn't got your point.

You can do the following the code in your edit script.

Load Parent Account

from test.xls

where account_type='Headquarters';

Regards,

Tom

Not applicable

Re: Load data only if a criteria is met

Thank you Tom for the info. What if I am bringing the data in from SalesForce? Will the code be the same?