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.