Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

shwetagupta
Contributor

Convert if condition to set analysis

Hi,

I want to convert this if condition into set analysis. Is it possible?

If(Num(Month(MaxInvoiceDate))- Num(Month(MinInvoiceDate))>=1 ,Count(distinct Contact_ID))

Thanks!!

Tags (1)
1 Reply
kkkumar82
Valued Contributor III

Re: Convert if condition to set analysis

Count(Distinct {<Contact_ID = {"=($(Num(Month(MaxInvoiceDate))- Num(Month(MinInvoiceDate))))>=1"}>}Contact_ID)

If you have a dimension, replace first Contact_ID with that

Community Browser