Qlik Community

Qlik Sense App Development

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

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
tomtastic
Not applicable

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.

Tags (2)
1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Set analysis current month and year

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

2 Replies
sunny_talwar
Not applicable

Re: Set analysis current month and year

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
Not applicable

Re: Set analysis current month and year

Thanks again for the support Sunny!