How to get Rolling Month using Set Analysis in Qlik

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,…

Read More

Set Analysis in QlikView

Set Analysis in QlikView and Its Components Set analysis is an advance expression in QlikView. It allows you to create data sets independent of your current selections. It’s mainly used in the comparative analysis. QlikView Set Analysis allows you to perform flexible aggregation. Usually aggregation occurs on the set of values in the current selection. But many…

Read More