Qlik Community

Qlik Sense App Development

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

Partner
Partner

Set analysis Previous month

Hi everyone,

I'm just trying to build an expression through set analysis for previous month:

=count({$<Month={num(month(addmonths(max(date_id),-1)),'00')}>}connect_time)

but I get this error (also shown on attached Image):

Error in set modifier ad hoc element list: ',' or ')' expected

It seems like a "," or ")" is missing but however much I check it I think expression is OK.

Could anyone help me please?

Thank you in advance!

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Set analysis Previous month

When using formula in set expression you need to use format below (in red):

=count({$<Month={"$(=num(month(addmonths(max(date_id),-1)),'00')"}>}connect_time)

 

This should work if the formula num(month(addmonths(max(date_id),-1)),'00') is ok

View solution in original post

2 Replies
Highlighted
Partner
Partner

Re: Set analysis Previous month

When using formula in set expression you need to use format below (in red):

=count({$<Month={"$(=num(month(addmonths(max(date_id),-1)),'00')"}>}connect_time)

 

This should work if the formula num(month(addmonths(max(date_id),-1)),'00') is ok

View solution in original post

Partner
Partner

Re: Set analysis Previous month

Thank you! It works  🙂