Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
pala_jagadeesh
Contributor III
Contributor III

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

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

Labels (3)
1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

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.

View solution in original post

1 Reply
micheledenardi
Specialist II
Specialist II

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.