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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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