Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
Anil_Babu_Samineni

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

Re: set analysis returns zero

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
Anonymous
Not applicable
Author

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.

Anonymous
Not applicable
Author

Got it, I found the problem