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: 
vanderson009
Creator III
Creator III

Set Analysis Issue in Qlik Sense

Can anybody help me with below set analysis, what is wrong with expression

=Sum({<Date={">=$(=QuarterStart(AddmMonths(AddYears(Today(),-3),1))"}>}Quantity)

15 Replies
Chanty4u
MVP
MVP

what do you want to achieve?

Chanty4u
MVP
MVP

Previous quarter ?

Sum({<Date={">=$(=Num(QuarterStart(AddYears(Max(Date),-1)))) <=$(=Num(AddYears(Max(Date),-1)))"}>}Sales)

vanderson009
Creator III
Creator III
Author

I want to display precious 12 Quarter data it means Previous 3 Years

Chanty4u
MVP
MVP

may be this?

sum({<Date = {">=$(addmonths(monthstart(today()), -36) <=$(today())"}>} Amount)

vanderson009
Creator III
Creator III
Author

I tried this, still no working..

Date format is also matching but don't know why data is not coming.

Chanty4u
MVP
MVP

try this

sum({<Date = {">=$(=addmonths(monthstart(today()), -36) <=$(=today())"}>} Amount)


vanderson009
Creator III
Creator III
Author

No luck . I wonder why this simple set analysis is not working

Chanty4u
MVP
MVP

share your sample app?

or

could you share your  date field values in filterpane?

vanderson009
Creator III
Creator III
Author

Its working in table expression but not in Line Chart

Do we need to do any setting at Line Chart level