Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Set Analysis

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,

Labels (2)
1 Reply
Highlighted
Master II
Master II

Have a look at the wonderful article by @Henric_Cronström 

 

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

 

regards

Pradosh

Learning never stops.