topic Re: Need help in set analysis in QlikView

Need help in set analysis

Anonymous — Tue, 28 Apr 2015 12:18:39 GMT

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.

Re: Need help in set analysis

Bill_Britt — Tue, 28 Apr 2015 12:20:55 GMT

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

Re: Need help in set analysis

sunny_talwar — Tue, 28 Apr 2015 12:21:56 GMT

Try this:

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

Best,

Sunny

Re: Need help in set analysis

Anonymous — Tue, 28 Apr 2015 12:48:14 GMT

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...

Re: Need help in set analysis

sunny_talwar — Tue, 28 Apr 2015 12:55:11 GMT

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

Re: Need help in set analysis

Anonymous — Tue, 28 Apr 2015 13:02:03 GMT

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

Re: Need help in set analysis

sunny_talwar — Tue, 28 Apr 2015 13:06:52 GMT

Give this a shot:

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

Re: Need help in set analysis

ankitaag — Tue, 28 Apr 2015 13:11:47 GMT

Please refer the attached application

Re: Need help in set analysis

ankitaag — Tue, 28 Apr 2015 13:12:37 GMT

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

Re: Need help in set analysis

Anonymous — Tue, 28 Apr 2015 13:52:52 GMT

Thanks Sunny.. It worked perfect.

Re: Need help in set analysis

sunny_talwar — Tue, 28 Apr 2015 13:58:52 GMT

Awesome , I am glad I was able to help.

Best,

Sunny