Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ptam1556
New Contributor

count if with like and equal as condition on a separate table

I am trying to use the data from the top table to create the bottom table. For example, "ID" 1 and "FIELD_ID" "A0001" can be found in  column D formula 3 times for "ID" = 1. It will output "COUNT_FORMULA" of 3. This excludes the ones with "ID" 2.

I first tried to separate (not joined) "COMPONENTS" in one table to lookup "CALCULATED" in another table.  It should match the ID and do something like a count on wildmatch/like for FIELD_ID in FORMULA.  However, I wasn't able to find the right syntax to do so.

Note is that something like row 5 is counted once each for row 17 and row 18 since it has both A0002 and A0001.

Thank you!

?ui=2&ik=999a97852c&view=fimg&th=160fe8f524a10d53&attid=0.1.1&disp=emb&realattid=img_5A5DD6DD029F014A003902FE_1@bloomberg.net&attbid=ANGjdJ-qgVpBq7db-i2TiFfA2MvQ08mzJKGbpRW7OMwUpQNGoFf7Xw45c_LTskGxQ_-iyJSmkKAkS0XGIZTc4wbApMpY6B22oVycuAiqpv2UHQvqwDYe2waxy8gaLsk&sz=s0-l75-ft&ats=1516104763580&rm=160fe8f524a10d53&zw&atsh=1

Tags (2)