topic Using max and min selection dates in QlikView

Using max and min selection dates

Mon, 22 May 2017 06:07:00 GMT

Hi QV community,

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

I have a data set containing the following:

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.

tresB — Mon, 22 May 2017 09:19:51 GMT

May be like (in a text box):

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

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

Mon, 22 May 2017 09:51:25 GMT

Thanks you very much.

Most helpful