topic Set Analysis Doubt in QlikView

Set Analysis Doubt

rcandeo — Tue, 16 Jun 2009 21:45:26 GMT

I need to calculate the sum of my sales quantity since january to the actual month(-1).

In above expression I have the result to the actual month-1:

sum( {$<Month = {$(#=Only(Month)-1)}>} Quantity_Item)

I´ve tried the next expression but i´ve got the sum of the actual month + actual month(-1):

sum( {$<Month < {$(#=Only(Month)-1)}>} Quantity_Item)

How I´ve got the sum of all months till actual month (-1)?

rcandeo — Wed, 17 Jun 2009 01:19:15 GMT

I am almost there. Using the expression above, I've got the number I need for this month, but I need to use (month) instead of 6.

sum( {$<Month = {">0<6"}>} Quantity_Item)

Anyone can help me?

Wed, 17 Jun 2009 01:57:34 GMT

Try this:

=sum( {$<Month = {">0<$(#=Month(Now()))"}>} Quantity_Item)