Need help in set analysis

[Anonymous]

Hi Friends,

I need some help to achieve the below.

1. Count the number of ID if the Start Date is today's date.

2. Count the number of ID if the today's date is between Start Date and End Date.

I crashed my brain to achieve this. Need your help.

[Bill_Britt]

Hi,

Take a look at these Video's when you have time.

      - Beginners’ Introduction to Set Analysis

• https://community.qlik.com/docs/DOC-8039
• - Set Analysis - Part 2 - Cool Stuff You Can Do
• https://community.qlik.com/docs/DOC-8174
  

[sunny_talwar]

Try this:

1. =Count({<[Start Date] = {"$(=Today())"}>}ID)
2. =Count({<[Start Date] = {"<=$(=Today())"}, [End Date] = {">=$(=Today())"} >}ID)

Best,

Sunny

[Anonymous]

Hi Sunny,

I tried Count({<[Start Date] = {"$(=Today())"}>}ID) and getting the count as 0. But I have 2 IDs with Start Date 28-Apr-2015.

What could be wrong...

[sunny_talwar]

Are you specifying a date format to your field [Start Date] in the script? Did the second expression work?

It would be easy if you can share a sample application.

Best,

Sunny

[Anonymous]

Yes

Date(ScheduledStartDate,'MM-DD-YYYY') as 'Start Date'

This how I am getting the Start Date.

The second expression also did not work.. But for both the expression I am getting 0. (Not an error or -)

[sunny_talwar · Accepted solution]

Give this a shot:

=Count({<[Start Date] = {"$(=Date(Today(), 'MM-DD-YYYY'))"}>}ID)

[ankitaag]

Please refer the attached application

[ankitaag]

Count({<[Start Date] = {"=$(=Today())"}>}ID)

[Anonymous]

Thanks Sunny.. It worked perfect.