Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
apthansh
Contributor

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
Highlighted
vishsaggi
Esteemed Contributor III

Re: Date condition in set analysis

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])