Need to add values before a particular date

[#1]

I would like to add values before a particular date and I am using following formula. Though the expression is OK, but I am still not able to get desired result.

if([Posting Date]<='2013/03/31',Sum(Quantity))

Please help me.

Regards

Sangeet Malhotra

[#2]

Hi,

You are trying to do it at script level or front end?

[aveeeeeee7en]

Try this:

=SUM({$<[Posting Date]={"<$(=makedate(2013,03,31))"}>}Amount)

Regards

Av7eN

[aveeeeeee7en]

Hi

PFA.

Regards

Av7eN

[#5]

Dear Aveen,

I am not able to open your qvw file as I am novice to Qlikview and using personal edition for same. My version is

[#6]

Hi Reshma,

I am entering it under Expression. Please do suggest.

Regards

Sangeet Malhotra

[#7]

Hi,

Try this

if(num([Posting Date])<=num(date(date#('2013/03/31','YYYY/MM/DD'))),Sum(Quantity))

[#8]

HI Reshma,

Though the expression is correct but results are not desirable. Actually I have a table which includes Store, Posting Date and Quantity. I would like to add quantity before a particular date but not able to do it. I would like to extract stock of a particular store and for a particular brand for a particular month. Please let me know how to handle it and explain the same so that you can help me out.

Regards

Sangeet

[jagan]

Hi,

Try like this

=Sum({<[Posting Date]={"<=$(Date(Date#('2013/03/31', 'YYYY/MM/DD')))}>}Quantity))

What is your Date format of [Posting Date] field?

Regards,

Jagan.

[#10]

Hi Jagan,

Please do have a look.