Date Range FIlter.

[vijayit43]

Hi Expert,

              My Data Model is Given Below and one end date is 20 dec 2015 we want to sum those customer data which posting date is greater then Approve Date and less than given date '20 dec 2015' how  to use expression please suggest.

CustomerCode	ApproveDate	Posting Date	Qty
CUST/00001	5/12/2015	6/12/2015	10
CUST/00002	6/12/2015	5/12/2015	8
CUST/00002	6/12/2015	8/12/2015	10
CUST/00002	6/12/2015	11/12/2015	10
CUST/00003	10/12/2015	7/12/2015	8
CUST/00003	10/12/2015	8/12/2015	10
CUST/00003	10/12/2015	15/12/2015	9
CUST/00003	10/12/2015	18/12/2015	12

[settu_periasamy · Accepted solution]

Try, if your customer code is your dimension..

=Sum ({<[Posting Date]={"> $(=Date([ApproveDate]))<20/12/2015"}>}Qty)

You can create one variable with inputbox, then you can use variable in the expression..

[Gysbert_Wassenaar]

Try Sum( If([Posting Date] > [ApproveDate] and [Posting Date] < MakeDate(2015,12,20), Qty))

[manishchandra_j]

Hi Gysbert,

Can we achieve same with set analysis? If yes then what will the expression?

[Gysbert_Wassenaar]

I don't think that can be done with the data you posted. See this document for an explanation: set_analysis_intra-record.qvw

[manishchandra_j]

Awesome!! Thanks a ton Gysbert!!

[vijayit43]

Hi settu_periasamy,

                              When we select One Customer then Its Work Fine But When Multiple Customer in Dimension then Sum All Record please Suggest.