Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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 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:
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
@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:
Hi @Taoufiq_Zarra ,
Thank you so much!!