Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

count of keywords?

hi,

i need to know how to script a expression to count the number of times a word appears in a column?

could you please assist?

=Count(if(Comments,'*BlackBerry*'))

5 Replies

Re: count of keywords?

Try:

Sum(if(Comments = '*BlackBerry*', 1 , 0))


let me know

Re: count of keywords?

Hi Marvin, for a sample data like:

LOAD * Inline [

words

BlackBerry

aid BlackBerry

BlackBerry 2

other words

];

You can use an expression like:

=Sum(Aggr(If(Index(words, 'BlackBerry'), 1, 0), words))

Re: count of keywords?

This is better:

Sum(if(WildMatch(Comments, '*BlackBerry*')>0, 1 , 0))

Not applicable

Re: count of keywords?

hi ,

Thanks Alessandro it works ...... awesome stuff....

Not applicable

Re: count of keywords?

thanks i will do this for the inline .... awesome stuff

Community Browser