Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Partner
Partner

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