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)

3 Replies

Re: set analysis returns zero

Not sure why you've created 2 threads for single problem. Try to avoid them

Re: set analysis returns zero

ronaldcadet
New Contributor

Re: set analysis returns zero

Anil, thanks for replying to my issue. Although I am seeing some values and the bar chart is reacting base on the number of months I am subtracting.  It's still showing all 12 months, the goal is to show the bar for the current 3 months of data.only without showing the remaining 9 months with no bars.

ronaldcadet
New Contributor

Re: set analysis returns zero

Got it, I found the problem