topic Re: problem with sum in QlikView

problem with sum

Anonymous — Thu, 20 Dec 2012 07:50:31 GMT

hi,

i build in the script feild that show each day number that i use for calculted.

if(match(WeekDay([date]),'sat'),num(0.15),
if(match(WeekDay([date]),'fri'),num(0.60),
if(match(WeekDay([date]),'sun','mon','tue','wed','thu'),num(1)))) as [action day]

when i want to use this feild - "action day" for sum, i'm geting not the right answer.

mybe this feild is not numeric ?

thanks'

yarin.

Re: problem with sum

sivarajs — Thu, 20 Dec 2012 08:49:47 GMT

Try this

if(wildmatch(WeekDay([date]),'sat'),num(0.15),
if(wildmatch(WeekDay([date]),'fri'),num(0.60),
if(wildmatch(WeekDay([date]),'sun','mon','tue','wed','thu'),num(1)))) as [action day]

Re: problem with sum

Anonymous — Thu, 20 Dec 2012 10:26:51 GMT

hi thanks',

but it's still doesn't work.

what can be the problem ?

Re: problem with sum

Gysbert_Wassenaar — Thu, 20 Dec 2012 10:59:21 GMT

Weekday returns an integer, not a string. You can use the pick function:

pick(weekday(date)+1,1,1,1,1,0.6,0.15,1) as [action day]

Re: problem with sum

Anonymous — Thu, 20 Dec 2012 11:33:21 GMT

hi,

it's desn't workink.

see attuched.