Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
Showing results for 
Search instead for 
Did you mean: 

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



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,





Labels (1)
1 Reply