Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

jbakerstull
Contributor

Create a set analysis expression

The formula below identifies a client as "New Household" if the client's first entry date is greater than or equal to start of report period.

The total number of "Yes" under New Household column is 202. I would like to display the total yes count in a condition block. What is the best way show the count? Would it be using KPI?

Can the formula below be concerted into set expression?

=If([Entry Date]>='4/01/2018' and (If([Entry Date] = Min(TOTAL <[Client Id]> [Entry Date]), 'First')) ='First','Yes','No')

Community Browser