Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
3 Keynotes, 100+ Breakout Sessions, 1 New York Times bestseller, and you. QlikWorld Online, May 10-12: REGISTER 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
Champion III
Champion III

what do you want to achieve?

Chanty4u
Champion III
Champion III

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
Champion III
Champion III

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
Champion III
Champion III

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
Champion III
Champion III

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