topic Re: Get Current month and previous month in QlikView

Get Current month and previous month

Anonymous — Fri, 15 Jun 2018 06:46:37 GMT

I need help...

I want to calculate current month and previous month. Eg. Suppose all data is selected then values show current month(May) data and previous month(April) data, and if user click on April month filter then variable need to show current month as April and previous month as March. Hope you understand the requirement.

Re: Get Current month and previous month

kfoudhaily — Fri, 15 Jun 2018 07:38:51 GMT

your requirement is clear and classic but this should be done in restitution part inside expressions depending what you need to calculate using set analysis

please have a look at this: Set Analysis Current Month vs Previous Month

else precise your data and what you need to calculate, sum, count...

Re: Get Current month and previous month

vikasmahajan — Fri, 15 Jun 2018 07:44:50 GMT

create this variable on load script:

et vPriorMonth = '=month(addmonths(max(GasDay),-1))';

let vPriorMonthYear = '=Year(addmonths(max(GasDay),-1))';

Then I used this for finding the last month charges

=SUM({<Year={'$(vPriorMonthYear)'},Month={'$(vPriorMonth)'}>} SalesValue)

Vikas