topic Re: Exclude keyword string in QlikView

Exclude keyword string

Anonymous — Thu, 24 Apr 2014 14:59:47 GMT

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,

whiteline — Thu, 24 Apr 2014 15:06:29 GMT

Hi.

Have you tried $-sign expansion ?

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

Anonymous — Thu, 24 Apr 2014 15:20:40 GMT

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

Thank you.