Qlik Sense : Finding values in different periods

[AnkitMadhukar]

Hi Everyone,

I have a requirement where I need to show Area where transactions happened last month but not this month.
I am trying to find an approach to do this (preferably at chart level instead of changing load script , as the condition of period selection can change )

So Assuming we have this table 

Month	Amount	Area
1-Jan-20	100	A
1-Jan-20	200	B
1-Jan-20	100	C
1-Feb-20	150	A
1-Feb-20	100	B

So if we see here , we don't have any transactions for area 'C' in Feb.
What can be the approach to get this result in Qlik? TIA!

Thanks
Ankit 

[Taoufiq_Zarra]

@AnkitMadhukar  I assume Year is 2021 not 2020

Maye be like this :

=Sum({<Area={"= sum({<Month={[$(=monthstart(today()))]}>}Amount)=0 and sum({<Month={[$(=monthstart(AddMonths(today(),-1)))]}>}Amount)>0"}>} Amount)

output:

[AnkitMadhukar]

Hi @Taoufiq_Zarra ,
Thank you for helping me with this!
 Is there a way to have the dimension value only (So that it can be used in filter pane). 
Thanks

[Taoufiq_Zarra · Accepted solution]

@AnkitMadhukar  in filtre like ?

=aggr(Only({<Area={"= sum({<Month={[$(=monthstart(today()))]}>}Amount)=0 and sum({<Month={[$(=monthstart(AddMonths(today(),-1)))]}>}Amount)>0"}>} Area), Area) 

output:

[AnkitMadhukar]

Hi @Taoufiq_Zarra ,

Thank you so much!!