Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
You are trying to do it at script level or front end?
Try this:
=SUM({$<[Posting Date]={"<$(=makedate(2013,03,31))"}>}Amount)
Regards
Av7eN
Hi
PFA.
Regards
Av7eN
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
Hi Reshma,
I am entering it under Expression. Please do suggest.
Regards
Sangeet Malhotra
Hi,
Try this
if(num([Posting Date])<=num(date(date#('2013/03/31','YYYY/MM/DD'))),Sum(Quantity))
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
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.
Hi Jagan,
Please do have a look.