topic Re: Variables and straight table calculation in QlikView

Variables and straight table calculation

maudifer — Wed, 21 Mar 2018 12:59:54 GMT

Hi All,

I have built the below straight table and variables. I am doing sums based on months or month averages.

I need to be able to change the Current month variable each month and have the calculate each column automatically.

The issue i am having is that it only works if the CurrentMonth variable is 12 (December). If i use any other month, it bugs because we are overlapping 2 different years. Can some help me with this ?

Re: Variables and straight table calculation

sunny_talwar — Wed, 21 Mar 2018 13:04:35 GMT

Would you be able to share a sample which shows the issue?

Re: Variables and straight table calculation

maudifer — Wed, 21 Mar 2018 14:49:19 GMT

Hi Sunny,

see below, when i change the current month and year, it does not work.

I first created this to report on Dec 17 and the below example i tried to report on Jan 18

but it seems to not work when I do that . It won't calculate anymore and it also does not know that the month before Month 1 of 2018 is month 12 of 2017

Do you know how I could set the variables to it knows what the previous month is even if it a different year ?

Thanks

Re: Variables and straight table calculation

settu_periasamy — Fri, 23 Mar 2018 19:08:18 GMT

May be try this

vpreviousmonth1

=Month(AddMonths(makeDate(2018,$(vCurrentmonth),1),-1))

vpreviousmonth2 :

=Month(AddMonths(makeDate(2018,$(vCurrentmonth),1),-2))