Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
apthansh
Creator
Creator

Date condition in set analysis

I have below date condition.How can I put this in set Analysis ?

count(distinct  if([Status]='Active', If(Date([Next Event Date])-date(today())>=0 AND Date([Next Event Date])-date(today())<=90,

                [ID])))

Thanks much

1 Reply
vishsaggi
Champion III
Champion III

Try this may be?

= Count(distinct {< [Status]={'Active'},

                    [ID] = {"=IF(Date([Next Event Date])-Date(Today())>=0 AND Date([Next Event Date])-date(today())<=90, [ID])"}

                  >}[ID])