10 Replies Latest reply: Aug 24, 2012 2:42 AM by Nilesh Gangurde

Date filters using Set Analysis

Hi,

Here's the sample Data:

Creation DatePDC DateCustomer NameAmountStatus
8/2/20128/6/2012Jesiel Jacob64,768Active
8/3/20128/5/2012Jesse McArthur89,899Active
8/5/20129/1/2012Sharon Concepcion34,900Close
8/6/20129/5/2012Martin Michael67,234Active

Say, I choose data 8/5/2012. It should display, PDC Date greater than the chosen date and Creation date is equal or less than the chosen date.

Thanks,

Bill

• Re: Date filters using Set Analysis

Hi Billringer,

try below expression:

Sum({<PDC Date = {">\$(=Max(PDC Date))"},Creation Date = {"<=\$(=Max(PDC Date))"}>} Amount)

Regards,

Nilesh Gangurde

• Re: Date filters using Set Analysis

Hi Nilesh.

Can u give me example? It's not working in my part! Thanks,b

• Re: Date filters using Set Analysis

Regards,

Nilesh Gangurde

• Re: Date filters using Set Analysis

Hi

It would help if you could be more specific about how you want to use the epxression. Is it in a straight or pivot table? What dimensions are there? Or do you want to show this in a list box?

Also, please try and be more specific about how it is not working. Is it returning nulls, or is it returning everything (ie filter not working) etc

Regards

Jonathan

• Re: Date filters using Set Analysis

Hi Brillinger

u can use following expression

Sum({<PDC_Date={">\$(=Max(PDC_Date))"},CreationDate={"<=\$(=Max(PDC_Date))"}>} Amount)

Regards

• Re: Date filters using Set Analysis

Thanks. I just got it!

• Re: Date filters using Set Analysis

GUYS, I got problem..

When I select date: 8/14/2012

It is different to

Month: Aug

Day: 14

Year: 2012

How to do that in set analysis?

I GUESS, I should separate Year, Month, Day --- what do you think?

• Re: Date filters using Set Analysis

Hi billiringer,

Make Master calender with the Year, Month,Day and use the above expression for the same to have data according to selections.

Regards,

Nilesh Gangurde