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

Anonymous — Wed, 22 Dec 2021 15:42:54 GMT

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

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

eduardo_dimperio — Tue, 29 May 2018 17:33:17 GMT

I think this could help you:

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

topic Can you help me in counting specific text in several columns? in App Development

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

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