topic Last 3 Years in QlikView

Last 3 Years

Sat, 03 Oct 2015 05:38:24 GMT

Hi Experts,

I want to calculate last 3 years Sales in Pivot table. Please help me how to achieve this

Thanks in Advance

sunny_talwar — Sat, 03 Oct 2015 22:42:24 GMT

May be use this expression:

Sum({<Year = {"$(='>=' & Max(Year) - 2)"} Sales)

Sun, 04 Oct 2015 03:37:07 GMT

Its not working Sunny

jagan — Sun, 04 Oct 2015 06:59:11 GMT

HI,

Try like this

Sum({<Year = {">=$(=Max(Year) - 2)<=$(=Max(Year))"} Sales)

Check this link for more options

Set Analysis for certain Point in Time

Regards,

Jagan.

Anonymous — Sun, 04 Oct 2015 07:32:21 GMT

hi,

Sum({<Year = {">=$(=Year(Today() - 2))"}>}Sales)

Sum({<Year = {">=$(=Max(Year) - 2)<=$(=Max(Year))"}>}Sales)

Regards

Neetha

Anonymous — Sun, 04 Oct 2015 08:57:31 GMT

Hi Abhi,

Please try like this:

Sum({<Year = {">=$(=Max(Year) - 2)<=$(=Max(Year))"}>} Sales)

Hope it helps!!

Sun, 04 Oct 2015 11:51:04 GMT

Thank You Jagan

Mon, 05 Oct 2015 05:37:39 GMT

Thank You Neetha