topic Re: Get Previous Month Value in QlikView

Get Previous Month Value

bharatkishore — Wed, 07 Feb 2018 09:46:41 GMT

Hi All,

I have a year field where it has 2015,2016,2017.2018.

Now i have one fields Current year and now i need to get previous year value for that.

For example in current year i have 2015,2016,2017.2018 values like below

Now i need to get the output like below is there any way i can achieve it.

Thanks,

Bharat

tresB — Wed, 07 Feb 2018 09:52:46 GMT

In a chart? You can probably use above() like:

Above(Sum(Value))

VishalWaghole — Wed, 07 Feb 2018 10:57:48 GMT

Above(Sum(Currentyear))

Hope this will work for you.

Thanks,

Vishal