Discussion Board for collaboration related to Qlik Education.
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?
Sum(if(Comments = '*BlackBerry*', 1 , 0))
let me know
Hi Marvin, for a sample data like:
LOAD * Inline [
You can use an expression like:
=Sum(Aggr(If(Index(words, 'BlackBerry'), 1, 0), words))
This is better:
Sum(if(WildMatch(Comments, '*BlackBerry*')>0, 1 , 0))
Thanks Alessandro it works ...... awesome stuff....
thanks i will do this for the inline .... awesome stuff