Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
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