Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
LordGrim
Contributor III
Contributor III

Next meeting date (after today) as a KPI

I have a meeting_date field which is includes all post and future meeting dates. I want to show the 'next' meeting date after today?

I have a Max(meeting_date) which shows me the last meeting date booked but I know want to bring in a min after today()? Any ideas? Its DD/MM/YYY format for the UK.

Thanks

 

 

Labels (1)
1 Solution

Accepted Solutions
dplr-rn
Partner
Partner

try

min({<meeting_date={">$(=today())"}>}meeting_date)

View solution in original post

4 Replies
dplr-rn
Partner
Partner

use set analysis something like below

count({<meeting_date={">$(=today())"}>}meetingid)

 

LordGrim
Contributor III
Contributor III
Author

Thanks ... I just want to display the 'Next date', not sure I made that clear. 

dplr-rn
Partner
Partner

try

min({<meeting_date={">$(=today())"}>}meeting_date)

LordGrim
Contributor III
Contributor III
Author

 Yes and thankyou - worked fine. 😁