Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
danielnevitt
Creator
Creator

Triggers

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

6 Replies
bbi_mba_76
Partner - Specialist
Partner - Specialist

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.

Not applicable

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
Creator
Creator
Author

Thank you for your replies

danielnevitt
Creator
Creator
Author

Sorry just another quick question.

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

Thanks,

Daniel

Not applicable

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

danielnevitt
Creator
Creator
Author

Hi Selvakumar,

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

Thanks,

Daniel