Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Not applicable

Using max and min selection dates

Hi QV community,

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

I have a data set containing the following:

EventDateEventValue1EventValue2
01/01/201611
02/02/201622
03/03/201610
04/04/201611
05/05/201601
06/06/201620
07/07/201611
08/08/201610
09/09/201601

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.

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Using max and min selection dates

May be like (in a text box):

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

-

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

Re: Using max and min selection dates

May be like (in a text box):

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

-

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

View solution in original post

Highlighted
Not applicable

Re: Using max and min selection dates

Thanks you very much.

Most helpful