Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
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