Master Calendar and Set Analysis date ranges

Anonymous — Thu, 20 Feb 2014 22:39:39 GMT

Hello,

Is there a way to get a range in the expression?

For instance, I'm trying to find amounts where if a due date is less than the master calendar date but 30 days or less than the master calendar date, show the amount.

I'm thinking it would be something like this but it's all 0's:

Sum({$<DUEDATE={"<=$(=max(Master_Calendar.Date)<=$(=num(DUEDATE)-30))"}>}AMOUNT)

Thank you in advance.

Re: Master Calendar and Set Analysis date ranges

Thu, 20 Feb 2014 23:15:38 GMT

try like this

create the variable like

Vmaxcaldate=max(date(Master_Calendar.Date,'DD/MM/YYYY'))

Vprev30days= max(date(DUEDATE,'DD/MM/YYYY'))-30

Use the variable in set

Sum({$<DUEDATE={'>=$(Vmaxcaldate)<=$(Vprev30days)'}>}AMOUNT)

topic Master Calendar and Set Analysis date ranges in QlikView

Master Calendar and Set Analysis date ranges

Re: Master Calendar and Set Analysis date ranges