topic How is the correct syntax? in QlikView

How is the correct syntax?

rcandeo — Fri, 09 Mar 2012 20:42:30 GMT

Hi, I need to make this expression in my dinamic table and I'm not finding the right way:

sum (if(weekday(yesterday)='sun',{1<Date={'$(DateYesterday2)'}, Company={'ADBR'}>}, {1<Date={'$(DateYesterday1)'}, Company={'ADBR'}>} Quantity)

Anyone can give me a hint?

This expression works:

sum ({1<Date={'$(DateYesterday2)'}, Company={'ADBR'}>} Quantity)

Thanks

How is the correct syntax?

Fri, 09 Mar 2012 21:09:02 GMT

It doesn't appear to be working that way on my end either, a possible workaround might be to define two variables

var1 = sum ({1<Date={'$(DateYesterday2)'}, Company={'ADBR'}>} Quantity)

var2 = sum ({1<Date={'$(DateYesterday1)'}, Company={'ADBR'}>} Quantity)

Then you can just do if(weekday(yesterday)='sun',var1, var2) in your table.

Hope this helps.

Re: How is the correct syntax?

Fri, 09 Mar 2012 21:19:54 GMT

You can also just put 2 seperate expression using the if:

if(weekday(yesterday)='sun',

sum ({1<Date={'$(DateYesterday2)'}, Company={'ADBR'}>} Quantity),

sum({1<Date={'$(DateYesterday1)'}, Company={'ADBR'}>}Quantity))

Or you can just create one variable that uses the same if statement:

DateYesterday=if(weekday(yesterday)='sun','Expression','Expression2')

Then do:

sum({1<Date={'$(DateYesterday)'}, Company={'ADBR'}>}Quantity))

Re: How is the correct syntax?

CELAMBARASAN — Sat, 10 Mar 2012 05:16:39 GMT

Hi,

Check with this

if(weekday(yesterday)='sun',sum ({1<Date={'$(DateYesterday2)'}, Company={'ADBR'}>} Quantity), Sum({1<Date={'$(DateYesterday1)'}, Company={'ADBR'}>} Quantity))

Celambarasan

How is the correct syntax?

jagan — Sat, 10 Mar 2012 05:26:28 GMT

Hi,

Qlikview is case sensitive, so 'sun' should be 'Sun', and your expression should be like below

= if(WeekDay(yesterday)='Sun', Sum ({1<Date={'$(DateYesterday2)'}, Company={'ADBR'}>} Quantity), Sum({1<Date={'$(DateYesterday1)'}, Company={'ADBR'}>} Quantity))

Regards,

Jagan.