topic Re: Conditional script loading in QlikView

Conditional script loading

Mon, 02 Sep 2013 10:35:32 GMT

I am creating a database to contain similar data sets across different clients. My aim is to build one data warehouse, and then a Qlikview app for each client, skinned in the correct branding, look and feel etc. How can I load the data into QlikView based on just one client name.

For example, an abbreviated version of the script is below, how do I adjust the script to load only where client is equal to "simon"

With many thanks,

Simon

LOAD

Client,

Metric,

Channel,

Month,

Leads,

Forecast

FROM

File location

Re: Conditional script loading

tresB — Mon, 02 Sep 2013 10:41:00 GMT

Section access implementation could be better i believe. However, to achieve what you want, can try something like this:

LOAD

Client,

Metric,

Channel,

Month,

Leads,

Forecast

FROM

File location where Client='Clientnameyouwant';

Re: Conditional script loading

Mon, 02 Sep 2013 10:57:36 GMT

Thank you tresesco, I had a bit of lplaying around because of embedding labels, but worked perfectly after that.

Thank you for you advice,

Simon