# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

## set analysis returns zero

I hope someone can help me find out what is wrong with this set expression.  The result is always zero no matter what i try to do to it.

=Count({\$<CalendarMonthYear ={"\$(= '<=' Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

1 Solution

Accepted Solutions
MVP

## Re: set analysis returns zero

This should like

=Count({\$<CalendarMonthYear ={"<=\$(=Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

OR

=Count({\$<CalendarMonthYear ={"\$('<=' & =Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

2 Replies
MVP

## Re: set analysis returns zero

This should like

=Count({\$<CalendarMonthYear ={"<=\$(=Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

OR

=Count({\$<CalendarMonthYear ={"\$('<=' & =Date(MonthStart(Max(CalendarMonthYear),-1)), 'MMM-YYYY')"},Object_A={"<=30"}>} Distinct  Jobs)

MVP

## Re: set analysis returns zero

For your expression you are missing a \$... and you also had a misplaced parenthesis

=Count({\$<CalendarMonthYear = {"\$(='<=' & Date(MonthStart(Max(CalendarMonthYear),-1), 'MMM-YYYY'))"}, Object_A ={"<=30"}>} DISTINCT Jobs)