Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ronaldcadet
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

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

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
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)