topic Re: Set Analysis With Date Ranges in QlikView

Set Analysis With Date Ranges

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Good Day All,

Having some difficulty here. I am looking for a calculation within two dates.

vToday = date(Today())

vWeekAhead = date(Today()+8)

My set analysis formula is the below :

=Sum({<ReqShipDate = {">= $(vToday) <= $(vWeekAhead)"}>}MStockUnitMass*MOrderQty)

When I use this formula in a chart i can see that the result is what I want :

=Sum({<ReqShipDate = {">= 2018/03/12 <= 2018/03/20"}>}MStockUnitMass*MOrderQty)

But for some reason the calculation isn't correct, it doesn't show any data, although there really is data available. I've tried some of the below solutions. none worked.

=Sum({<ReqShipDate = {'>= $(vToday) <= $(vWeekAhead)'}>}MStockUnitMass*MOrderQty)

=Sum({<ReqShipDate = {'>= $(=vToday) <= $(=vWeekAhead)'}>}MStockUnitMass*MOrderQty)

Please assist.

Regards,

Re: Set Analysis With Date Ranges

tresB — Mon, 12 Mar 2018 09:04:40 GMT

Make sure that your ReqShipDate is a proper date(dual) field and format and the comparison date format are same, i.e. - YYYY/MM/DD

Re: Set Analysis With Date Ranges

Anonymous — Mon, 12 Mar 2018 09:08:34 GMT

I did, the Reqshipdate is in the format YYYY/MM/DD

I have adapted the variables to also be the same format. Still didn't work, I did however notice now that if I changed the formula to =Sum({<ReqShipDate = {"= $(vToday)"}>}MStockUnitMass*MOrderQty) Just as a test, it works, as soon as I add the greater than ">" things don't work.

Re: Set Analysis With Date Ranges

tresB — Mon, 12 Mar 2018 09:10:54 GMT

Could you post a sample app to investigate?

Re: Set Analysis With Date Ranges

Anonymous — Mon, 12 Mar 2018 09:22:39 GMT

Just reloaded the data and it worked.

Not sure what the issue was but the formula posted originally was correct.

Thanks for the help.

Re: Set Analysis With Date Ranges

shiveshsingh — Mon, 12 Mar 2018 10:20:59 GMT

Please close the thread