Set Analysis

[arvindjha2050]

Hello Team,

I have a Date field.

I am extracting Year(Date) field and keep it as Dimension.

For example it has values 2017 , 2018 , 2019

For 2019 , we require sum for last 12 months so 10 months fall in 2018.

Is there any way i can fetch 2018 values for dimension value 2019?

Thanks,

[pradosh_thakur · Accepted solution]

Have a look at the wonderful article by @hic 

https://community.qlik.com/t5/Qlik-Design-Blog/The-As-Of-Table/ba-p/1466130

regards

Pradosh