timestamp or month back

Mon, 04 Apr 2011 11:47:56 GMT

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?

timestamp or month back

Mon, 04 Apr 2011 12:14:31 GMT

OK,

I have to exclude mes_any field...

topic timestamp or month back in QlikView

timestamp or month back

timestamp or month back