Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

6 Months trend on user date selection

hello,

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

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

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.

View solution in original post

2 Replies
Highlighted
Partner
Partner

Highlighted
Contributor III
Contributor III

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.

View solution in original post