Qlik Community

Qlik Sense App Development

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

Announcements
See why BI users voted Qlik #1 in 11 categories. GET REPORT
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.