Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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])