Skip to main content

App Development

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

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
tomtastic
Contributor II
Contributor II

Set analysis current month and year

Hi,

I want to have a set analysis in place which automatically filters a graph on the last month which is available in the data set.

I've read multiple topics about this and tried the suggested solutions but didn't get the desired result and haven't got a clue where the problem might lie. Therefore I attached a sample if someone wants to take a deeper look.

Also see the attached print screen for a visual overview of the desired result.

Thanks in advance for your time.

1 Solution

Accepted Solutions
sunny_talwar

Try these expression

This month:

Count({<Date = {"$(='>=' & Date(MonthStart(Max(Date))) & '<=' & Date(Max(Date)))"}>}Notification)

This year:

Count({<Date = {"$(='>=' & Date(YearStart(Max(Date))) & '<=' & Date(Max(Date)))"}>}Notification)


Capture.PNG

View solution in original post

2 Replies
sunny_talwar

Try these expression

This month:

Count({<Date = {"$(='>=' & Date(MonthStart(Max(Date))) & '<=' & Date(Max(Date)))"}>}Notification)

This year:

Count({<Date = {"$(='>=' & Date(YearStart(Max(Date))) & '<=' & Date(Max(Date)))"}>}Notification)


Capture.PNG

tomtastic
Contributor II
Contributor II
Author

Thanks again for the support Sunny!