Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

vanderson009
Contributor

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
sureshqv
Esteemed Contributor III

Re: Set Analysis Issue in Qlik Sense

what do you want to achieve?

sureshqv
Esteemed Contributor III

Re: Set Analysis Issue in Qlik Sense

Previous quarter ?

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

vanderson009
Contributor

Re: Set Analysis Issue in Qlik Sense

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

sureshqv
Esteemed Contributor III

Re: Set Analysis Issue in Qlik Sense

may be this?

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

vanderson009
Contributor

Re: Set Analysis Issue in Qlik Sense

I tried this, still no working..

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

sureshqv
Esteemed Contributor III

Re: Set Analysis Issue in Qlik Sense

try this

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


vanderson009
Contributor

Re: Set Analysis Issue in Qlik Sense

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

sureshqv
Esteemed Contributor III

Re: Set Analysis Issue in Qlik Sense

share your sample app?

or

could you share your  date field values in filterpane?

vanderson009
Contributor

Re: Set Analysis Issue in Qlik Sense

Its working in table expression but not in Line Chart

Do we need to do any setting at Line Chart level