Set analysis

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement.

I have a Due date field in DD/MM/YYYY format. From that field based on Weekday need to derive the below Measure.

Count(Distinct issuenum) where duedate>= start of week(Monday) and <=end of week(sunday)

how to add the where condition on set analysis. Please help me on this.

Thanks in advance.

[qv_testing]

try this...

Count(Distinct issuenum) where

duedate>= weekStart(duedate) and <=Weekend(duedate)

Or

=Sum({<OrderDate={'>=$(=WeekStart(OrderDate))<=$(=WeekEnd(OrderDate))'}>}OrderSalesAmount)

[PrashantSangle]

try

count({<dateField={">=$(=date(weekstart(duedate)))<=$(=date(weekend(duedate)))"}>} issuenum)

Regards,

[shiveshsingh]

May be this

Count({<Weekday(Date(DueDate,'DD')) = {">=$(=weekday(WeekStart(DueDate,0,0)))<=$(=weekday(Weekend(DueDate,0,0)))"}>}Distinct issuenum)

[shiveshsingh]

What's the format of your Duedate?

[bhavvibudagam]

Its MM/DD/YYYY

[shiveshsingh]

=Count(DISTINCT{<DueDate ={">=$(=Date(WeekStart(DueDate,0,0),'MM/DD/YYYY'))<=$(=Date(Weekend(DueDate,0,0),'MM/DD/YYYY'))"}>}issuenum)

Try this

[bhavvibudagam]

Hi Shivesh,

Now getting 0

Thanks

[shiveshsingh]

Please share your app once

[bhavvibudagam]

Hi Shivesh,

Sorry. I cant share the app its a large data file.