Can you help me in counting specific text in several columns?

[Anonymous]

Hello,

I'm new in this community and learning Qlik... 

I’d like to create a dynamic dashboard and succeeded quite well, except for one formula. 

My goal is to count the number of ‘a specific text’ in several columns. 

I attached the excel file that I used and in the first tab, you’ll see the excel formula I used in Excel, that I can’t replicate this in Qlik…(=SUMPRODUCT(--(ISNUMBER(FIND(B1;Table1[['[Value Allocation Form'] Detailed Value Driver 1a]:['[Value Allocation Form'] Detailed Value Driver 3d]])))))

Can you help me ?

Many thanks in advance,

Greg

[eduardo_dimperio]

I think this could help you:

https://help.qlik.com/en-US/sense/April2018/Subsystems/Hub/Content/Scripting/ConditionalFunctions/wi...