WHERE MATCH statement in script to limit data loaded into dashboard

mattphillip — Wed, 10 Dec 2014 15:31:36 GMT

Hoping someone can help. I'm using a where match statement in my script to limit the programmes loaded into my dashboard and it works - to a point. Whilst it does indeed limit the data to those programmes explicitly mentioned in the where match statement, it doesn't limit the 'Programme' field values displayed in the multi-box featured on the dashboard (I don't know how or where its pulling this data from). Whilst the user can select the other programmes, no data is displayed. Is there anyway to use a where match statement to limit both the data loaded in, but also the vales displayed in objects on a dashboard?

Script below:

LOAD [Student ID],

Student,

[New/Ret],

Programme,

Level,

Mode,

Stg,

Domicile,

Postcode,

[Date of Birth],

Age,

Gender,

Disability,

Ethnicity

FROM

(ooxml, embedded labels, table is [Source Data]) Where Match(Programme,'BA (Hons) Business Studies','BA (Hons) Computer Arts');

Can anyone help?

Appreciated.

Matt

topic WHERE MATCH statement in script to limit data loaded into dashboard in QlikView

WHERE MATCH statement in script to limit data loaded into dashboard