Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Exclude keyword string

Hi folks,

I have input box ExcludeKeyword variable, where I type what I want to exclude from name of tags.

I want to exclude dynamically all tags from field Keyword

Count({<[Keyword]=-{'*coat*'}>}Keyword)  -----------it works

Please help me to add my variable ExcludeKeyword instead of "coat" to my expression.

Thanks,

1 Solution

Accepted Solutions
whiteline
Master II
Master II

Hi.

Have you tried $-sign expansion ?

Count({<[Keyword]=-{'*$(ExcludeKeyword)*'}>}Keyword)

View solution in original post

2 Replies
whiteline
Master II
Master II

Hi.

Have you tried $-sign expansion ?

Count({<[Keyword]=-{'*$(ExcludeKeyword)*'}>}Keyword)

Anonymous
Not applicable
Author

I thought it wouldn't work, because it's between ' '.

Thank you.