Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

timestamp or month back

Hi,

I have two fields selectors: month and day,

what I need is to go back one year even if I select day or month, I've tried something like this:

if(isnull(getfieldselections(day))='-1',

Sum ({<month={"$(=date(addyears(only(month),-1)))"}>}IMP_DESC),

Sum ({<day={"$(=date(addyears(only(day),-1)))"}>}IMP_DESC))

But it doesn't work if both fields are selected, I need to use the day selection in that case,

any idea?

1 Reply
Not applicable
Author

OK,

I have to exclude mes_any field...