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
