I have one issue in qliksense

[sbkumar]

I have this expression in qliksense.now i want Rolling months of last 12 months.how to modify that expression
?

=if(DATE > YearStart(AddYears(Today(),-1)) AND DATE <= Date(Today()),Month(DATE),)

[shraddha_g]

Try below code in Set analysis:

Date ={">=$(= date(addmonths(max(Date),-12))) <= $(=Date(Max(Date)))"}

[sbkumar]

not able to get the result

[Thiago_Justen_]

I recommend you see the link below:

Set Analysis for Rolling Periods

Cheers

[sbkumar]

i have used that expression.can anyone pls help me to get rolling months for 6 months(previous 6 months)

[Thiago_Justen_]

See this: Calculating rolling n-period totals, averages or other aggregations

[MK9885]

Maybe
create a field in your backend script as below
If( YOURDATEFIELD> monthstart(addmonths(today(),-5)) and YOURDATEFIELD<= today(),1) as [Rolling 6]

In front end use [Rolling 6] ={1} in your set analysis