Set Analysis Issue in Qlik Sense

[vanderson009]

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

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

[Chanty4u]

No .

convert that table object to line thats it.

[agigliotti]

let's try this:

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

[rangam_s]

Can you provide sample values present under date field?

[agigliotti]

i think date field should have the same format specified in your script for date format settings.

[rangam_s]

Try this.

=Sum({<Date={">=$(=(AddMonths(MonthStart(Max(Date),-36))))"}>}Quantity)

Try to make X axis as continuous.

[sunny_talwar]

May be try this

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