Filter

[#1]

Hello,

I want to filter for the following, can one of you let me know if there is a way to do this.

If((Flag = 1 and Year = 2013) and (Flag = 0 and Year =2014), Sum(sales))

I'm not sure how to do this in Qlikview.

Thanks

[#2]

Based on this example, the below should work for you.

Only({<Flag={'1'},Year={'2013'}>+<Flag={'0'},Year={'2014'}>}Client)

hope that helps

Joe