Get max date using wildcard and set analysis?

[Anonymous]

I am having several problems with a chart function I am trying to write. I need to get the max date when several conditions are true. It is a simple query to run in SQL and looks like this:

SELECT Name,

               COUNT(*),

               MAX(Date)

   FROM Table

WHERE (ConditionA LIKE '%qualifier%' OR Condition B LIKE '%qualifier%')

      AND ConditionC = 'False'

GROUP BY Name

This query counts the number of instances where the conditions are true and finds the most recent occurrence where they were all true.

In Qlik Sense, it seems like the best way to go about this would be through set analysis, but I can't get the syntax to work.

I am unable to get wildcards or wildmatch to work in set analysis and have no idea how to use set analysis to get a max(date) calculation.

I am not married to set analysis if an if statement or other solution would work better.

[sunny_talwar · Accepted solution]

May be this

Max({<ConditionA = {"*qualifier*"}, ConditionC = {'False'}>+<ConditionB = {"*qualifier*"}, ConditionC = {'False'}>}Date)

[Anonymous]

Thanks Sunny, you are a wizard!