topic Re: Triggers in QlikView

Triggers

danielnevitt — Wed, 08 Jan 2014 11:55:51 GMT

Hi,

I would appreciate some help with the use of Triggers.

I am trying to restrict my data to not show where COST_CD = '-'

I created a Select in Field, where Field is COST_CD and Search String is =IF(NOT MATCH(COST_CD,('-')),COST_CD)

Thanks for your help.

Regards,

Daniel

bbi_mba_76 — Wed, 08 Jan 2014 11:59:12 GMT

Hi,

with '-' you are talking of null value or '-' ?

In the first case you could use select possible , in the second you could have two action: select in field '-' and then select excluded.

Wed, 08 Jan 2014 12:02:59 GMT

You need to display this everywhere or in a particular chart or sheet..

If it is everywhere then its better to write it in load itsef...

danielnevitt — Wed, 08 Jan 2014 12:29:03 GMT

Thank you for your replies

danielnevitt — Wed, 08 Jan 2014 12:38:53 GMT

Sorry just another quick question.

How would I exclude more than one value? eg - and additives?

Thanks,

Daniel

Wed, 08 Jan 2014 12:49:12 GMT

Use can use multiple parameter..........

danielnevitt — Wed, 08 Jan 2014 12:55:12 GMT

Hi Selvakumar,

Please can you explain what you mean by the multiple parameter?

Thanks,

Daniel