topic Nested if statements and Set Analysis in QlikView

Nested if statements and Set Analysis

Tue, 11 Sep 2012 20:41:54 GMT

Hi Everyone,

I am nesting some if statements and would like some assistance with the following expression. The if WeekDay 'Tue' is working, but if I add the first line to the expression it stops working. Can someone tell me why. I am attaching the file and if you open the expression for Last Week you will see this expression.

if (WeekDay([vToday])='Mon',(Sum({$<DaysFilled.Date = {'$(=vToday)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vSevenDayAgo)'} >}DaysFilled.Days)))

or if (WeekDay([vToday])='Tue',(Sum({$<DaysFilled.Date = {'$(=vOneDayAgo)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vEightDayAgo)'} >}DaysFilled.Days)))

Re: Nested if statements and Set Analysis

MayilVahanan — Tue, 11 Sep 2012 20:58:30 GMT

Try like this

if (WeekDay([vToday])='Mon',(Sum({$<DaysFilled.Date = {'$(=vToday)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vSevenDayAgo)'} >}DaysFilled.Days)),

if (WeekDay([vToday])='Tue',(Sum({$<DaysFilled.Date = {'$(=vOneDayAgo)'} >} DaysFilled.Days)-Sum({$<DaysFilled.Date = {'$(=vEightDayAgo)'} >}DaysFilled.Days))))

Hope it helps

Re: Nested if statements and Set Analysis

Tue, 11 Sep 2012 21:03:15 GMT

Thank you!