topic Re: Current month and previous month values are getting same in QlikView

Current month and previous month values are getting same

ashis — Wed, 25 Nov 2020 16:16:04 GMT

Hi ,

In my data model, I have month and year combination field as

Year(Date) * 12 + num(Month(Date)) as [Month Counter], I want to calculate current month vs previous month values. So I have two expression as

current month
avg({<[Month Counter]={'$(=MAX([Month Counter]))'}>} xxx)

previous month

avg({<[Month Counter]={'$(vPreviousMonthCounter)'}>} xxx)

vPreviousMonthCounter as

vPreviousMonthCounter=max([Month Counter]) -1

Both the values for current and previous month are getting same, however it is not correct . Is my expression wrong or do I need to use it in different way.

Please suggest.

Re: Current month and previous month values are getting same

shiveshsingh — Mon, 02 Apr 2018 06:11:26 GMT

What is the value of =MAX([Month Counter] and vPreviousMonthCounter

Re: Current month and previous month values are getting same

ashis — Mon, 02 Apr 2018 06:41:58 GMT

MAX([Month Counter] returns 24219 , that is March and

vPreviousMonthCounter returns 24218 that is Feb.

Re: Current month and previous month values are getting same

poojashribanger — Mon, 02 Apr 2018 06:46:53 GMT

you can use max(month) and max(month)-1 as well

Re: Current month and previous month values are getting same

poojashribanger — Mon, 02 Apr 2018 06:53:58 GMT

you can use this expression for previous month

sum({<DT_LCL={"$(=date(max(DT_LCL)-1))"}>}CHRN_CT)

you can use this for max(month)

sum({<DT_LCL={"$(=date(max(DT_LCL)))"}>}CHRN_CT)

Re: Current month and previous month values are getting same

shiveshsingh — Mon, 02 Apr 2018 09:28:18 GMT

Try in double quotes once.

avg({<[Month Counter]={"$(=MAX([Month Counter]))"}>} xxx)