topic Re: Date Range FIlter. in QlikView

Date Range FIlter.

vijayit43 — Fri, 20 Nov 2020 18:02:30 GMT

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

Re: Date Range FIlter.

settu_periasamy — Fri, 25 Dec 2015 04:20:21 GMT

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..

Re: Date Range FIlter.

Gysbert_Wassenaar — Fri, 25 Dec 2015 06:57:46 GMT

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

Re: Date Range FIlter.

manishchandra_j — Fri, 25 Dec 2015 09:00:19 GMT

Hi Gysbert,

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

Re: Date Range FIlter.

Gysbert_Wassenaar — Fri, 25 Dec 2015 09:47:43 GMT

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

Re: Date Range FIlter.

manishchandra_j — Fri, 25 Dec 2015 11:42:55 GMT

Awesome!! Thanks a ton Gysbert!!

Re: Date Range FIlter.

vijayit43 — Fri, 25 Dec 2015 12:00:26 GMT

Hi settu_periasamy,

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