I have a requirement to retrive data from Last 6 Month to Till date. How we can achieve this? Yes! we can achieve this by using Qlik Sense Set Analysis.

Step1: You have to create a variable say “vLastSixMonth” in Qlik Sense

Step2: You need to define the dynamic methods in variable. Such as AddMonth(YourDateField, -6). This variable will return exact date from 6 month back.

Step3: Then Call this variable in the Set Analysis Expression, in such a way that the transaction date should be greater than the date populating in the variable.

Eg: sum({$<YourDateField={“>=$(=vLastSixMonth)”}>}Price)

This Expression can be called in the measure of the chart to populate date from last 6 Month to Till Date. Refereed my Youtube Video for better reference.