Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
helge_jorg
Creator
Creator

Expression with filter on year at the same time as year 2015 is fixed

I hope that some of you can help with setting up an expression that makes it possible to filter on year at the same time as 2015 is fixed within the expression.

I have a dataset where I would like to subtract sum of remaining oil eq from a selected year, from sum of remaining oil eq at 2015. Year 2015 needs to be fixed, and I need to be able to select the first year by filtering.

I have tired with several expressions, with no success so far. Hopefully some of you can help me!

Sum({<[ReserveHistory.Year]>}[ReserveHistory.Remaining mill Sm3 o.e])

-

Sum({<[ReserveHistory.Year]={2015}>}[ReserveHistory.Remaining mill Sm3 o.e])

Cheers

Helge

1 Solution

Accepted Solutions
sunny_talwar

May be this

Sum([ReserveHistory.Remaining mill Sm3 o.e])

-

Sum({<[ReserveHistory.Year]={2015}>}[ReserveHistory.Remaining mill Sm3 o.e])

or if year is your dimension, then this

Sum([ReserveHistory.Remaining mill Sm3 o.e])

-

Sum(TOTAL {<[ReserveHistory.Year]={2015}>}[ReserveHistory.Remaining mill Sm3 o.e])

View solution in original post

2 Replies
sunny_talwar

May be this

Sum([ReserveHistory.Remaining mill Sm3 o.e])

-

Sum({<[ReserveHistory.Year]={2015}>}[ReserveHistory.Remaining mill Sm3 o.e])

or if year is your dimension, then this

Sum([ReserveHistory.Remaining mill Sm3 o.e])

-

Sum(TOTAL {<[ReserveHistory.Year]={2015}>}[ReserveHistory.Remaining mill Sm3 o.e])

helge_jorg
Creator
Creator
Author

Thanks Sunny!

Year is the dimension and now the expression works perfectly!