topic Re: Date filters using Set Analysis in QlikView

Date filters using Set Analysis

Thu, 23 Aug 2012 05:18:16 GMT

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

Re: Date filters using Set Analysis

nilesh_gangurde — Thu, 23 Aug 2012 05:31:01 GMT

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

Re: Date filters using Set Analysis

Thu, 23 Aug 2012 05:58:42 GMT

Hi Nilesh.

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

Re: Date filters using Set Analysis

senpradip007 — Thu, 23 Aug 2012 06:25:31 GMT

Hi Brillinger

u can use following expression

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

Regards

Pradip Sen

Re: Date filters using Set Analysis

nilesh_gangurde — Thu, 23 Aug 2012 07:19:36 GMT

Please attach the sample Data..

Regards,

Nilesh Gangurde

Re: Date filters using Set Analysis

jonathandienst — Thu, 23 Aug 2012 07:30:28 GMT

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

Thu, 23 Aug 2012 09:21:44 GMT

Thanks. I just got it!

Re: Date filters using Set Analysis

Thu, 23 Aug 2012 10:07:41 GMT

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

nilesh_gangurde — Fri, 24 Aug 2012 06:30:58 GMT

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

Re: Date filters using Set Analysis

Fri, 24 Aug 2012 06:37:26 GMT

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

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

Re: Date filters using Set Analysis

nilesh_gangurde — Fri, 24 Aug 2012 06:42:05 GMT

If possible please attach the qvw file with sample data.

Regards,

Nilesh Gangurde