Date filters using Set Analysis

[#1]

Hi,

Here's the sample Data:

Creation Date	PDC Date	Customer Name	Amount	Status
8/1/2012	8/7/2012	Adrian Luke	78,000	Active
8/2/2012	8/6/2012	Jesiel Jacob	64,768	Active
8/3/2012	8/5/2012	Jesse McArthur	89,899	Active
8/5/2012	9/1/2012	Sharon Concepcion	34,900	Close
8/6/2012	9/5/2012	Martin Michael	67,234	Active

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

[nilesh_gangurde]

Hi Billringer,

try below expression:

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

Add Customer Name in Dimension

Regards,

Nilesh Gangurde

[#3]

Hi Nilesh.

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

[senpradip007]

Hi Brillinger

u can use following expression

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

Regards

Pradip Sen

[nilesh_gangurde]

Please attach the sample Data..

Regards,

Nilesh Gangurde

[jonathandienst]

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

[#7]

Thanks. I just got it!

[#8]

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?

[nilesh_gangurde]

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

[#10]

I already have master calendar, check the problem on this link. Thanks please.

http://community.qlik.com/message/251330#251330