Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

   

 

Labels (1)
1 Reply