Solved: Rolling 6 months(last 6 months sales from selected... - Qlik Community

pala_jagadeesh · ‎2022-09-30

Hi, when selecting date 25/3/2022

it gives a sum(sales) up to 6 months like below

From 25/3/2022 to 25/9/2021

micheledenardi · ‎2022-09-30

Try a solution like:

sum({<Date={"$(>=Date(AddMonths(Max(Date),-6),'DD.MM.YYYY'))<=Date(Max(Date),'DD.MM.YYYY'))"}>} sales)

Probably it needs to be adjusted a little but is a good starting point

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

micheledenardi · ‎2022-09-30

Try a solution like:

sum({<Date={"$(>=Date(AddMonths(Max(Date),-6),'DD.MM.YYYY'))<=Date(Max(Date),'DD.MM.YYYY'))"}>} sales)

Probably it needs to be adjusted a little but is a good starting point

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

Rolling 6 months(last 6 months sales from selected date)