Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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?

Labels (1)
1 Reply
Not applicable
Author

OK,

I have to exclude mes_any field...