topic Set analysis range in QlikView

Set analysis range

bobbydave — Wed, 25 Nov 2020 16:16:04 GMT

I guess this is trivial but i am going nuts but can someone assist

I am trying to get a range between the last 3 months and today.

=sum({< YearMonth = {"'>=' & MonthStart(AddMonths(today(),-6)) & '<=' & MonthStart(AddMonths(Today()))"} >} Security_Total)

The range is confusing me when using within set analysis

sunny_talwar — Mon, 24 Apr 2017 15:01:32 GMT

May be this

=Sum({<YearMonth = {"$(='>=' & MonthStart(Today(), -3) & '<=' & MonthStart(Today()))"}>} Security_Total)

snehamahaveer — Mon, 24 Apr 2017 15:29:10 GMT

Hi David,

May be you could try using this..

If you are specific with dates, then the one below.

Sum({<YearMonth = {'>=Addmonths(Today(),-3) <= Today()'}>}Security_Total)

if you want 3 months including the current month,

Sum({<YearMonth = {'>=Addmonths(Monthstart(Today()),-3) <=Monthstart(Today())'}>}Security_Total)

Hope it helps,