6 Months trend on user date selection

[Sameer9585]

hello,

I need to know how to calculate 6 months trend of previous months based on the selected month

[Pato1984]

you can use addmonth (maxdate,-6) 

https://help.qlik.com/fr-FR/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/Da...

[ashok_rajm · Accepted solution]

Hi,
You can Calculate Start and end date in Variable and use those variable in Set analysis, But make sure Field Value format and Variable Value format are same -
Sum({<Reporting={'>= $(vStart_Date) <= $(vEnd_Date)'}>} Values)

vStart_Date = addmonths(Max(Date),-6)
vEnd_Date = Max(Date)

Hope this Helps.