Using max and min selection dates

[#1]

Hi QV community,

I would really apreciate any help regarding an issue I encountered.

I have a data set containing the following:

EventDate	EventValue1	EventValue2
01/01/2016	1	1
02/02/2016	2	2
03/03/2016	1	0
04/04/2016	1	1
05/05/2016	0	1
06/06/2016	2	0
07/07/2016	1	1
08/08/2016	1	0
09/09/2016	0	1

I need to display the sum of EventValue1 below max selection date minus sumof EventValue2 below min selection date.

I tried verious combinations but nothing seems to work for me.

Thanks in advance.

[tresesco · Accepted solution]

May be like (in a text box):

=Sum({<EventDate={'<$(=Date(Max(EventDate))) '}>}EventValue1)

-

Sum({<EventDate={'<$(=Date(Min(EventDate)))'}>}EventValue1)

[#3]

Thanks you very much.

Most helpful