topic Problem with variable in the Sum Expression in QlikView

Problem with variable in the Sum Expression

Thu, 15 Mar 2012 07:45:33 GMT

Hi, I trying to set several expression which should return the sum of the Amount of the Remaining Invoices (Not yet paid). One for the Current week and the others from the previous weeks. The expression CurrentWeek is like that:

Sum({<CalendarWeek={$(vCurrentWeek)}>} [Remaining Invoices.Amount])

And It works.But when I try to set the sum for the previous weeh (CurrentWeek - 1) it fails

Sum({<CalendarWeek={$(vCurrentWeek-1)}>} [Remaining Invoices.Amount])

What Am I doing wrong ?

Thanks in advance.

Problem with variable in the Sum Expression

jagan — Thu, 15 Mar 2012 07:49:10 GMT

Hi,

Try this

Sum({<CalendarWeek={'$(=(vCurrentWeek-1))'}>} [Remaining Invoices.Amount])

Hope it helps you.

Regards,

Jagan.

Problem with variable in the Sum Expression

Thu, 15 Mar 2012 07:56:46 GMT

That's right! thanks a lot!