set analysis help

[#1]

Hi All

Need a help in set analysis.

we have a scenario

Table1:
Load * inline

[

D1                  , Key

5/1/2015  , A

6/1/2015, B

7/1/2015, C

];

And we have a calendar linked which has all dates.

Need count(key) where (date selected - D1)>5

Please help with the set analysis expression for this.

Suppose date selected is 11/1/2015, count of key is 1, as

11-5=6  for A

11-6 = 5 for B

11-7 = 4 for c

Only for A, the difference is >5.

Thanks.

[PrashantSangle · Accepted solution]

Hi,

Try like

count(if(interval(date_SelectedField-D1,'D')>5),key)

Regards

[its_anandrjs]

Hi,

Try this expression

Count(if(interval(GetFieldSelections( YourCalendarDate )-D1,'D') > 5,Key))

Regards

Anand