Conditional script loading

[#1]

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

[tresesco · Accepted solution]

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';

[#3]

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