topic Set Analysis - Select dates less than date in selection in QlikView

Set Analysis - Select dates less than date in selection

Wed, 09 Nov 2011 10:42:29 GMT

Hi QV Community,

I have a problem with creating a calculation that sums quantites for a date range prior to the date selected. See attached qvw-file. i just can't get the set analysis right.

That is, i have a column that should sum the transaction quantities for all dates prior to the selected date (date selected by user in the dale list box).

This way, i will be able to get the inventory quantity at any day in history.

Any help is much appreciated.

Thanks,

Philip

Set Analysis - Select dates less than date in selection

Wed, 09 Nov 2011 10:53:17 GMT

Hi Philip,

I can't open your model right now, but have you tried something with implicit field value definition:

Something like:

sum( {$<ORDERS = P({$<DATE={"<=$(=vYourDateVariable )) )"}>} ) >} total <PRODUCT> QTY)

:: sum qty in selection where your reference date is less than your date variable

Regards

Arthur

Re: Set Analysis - Select dates less than date in selection

perumal_41 — Wed, 09 Nov 2011 11:09:14 GMT

Hi Philip,

I attached one file .Check this file is correct or not .Any Problem replay.

Re: Set Analysis - Select dates less than date in selection

Wed, 09 Nov 2011 11:28:58 GMT

Hi Philip,

You just need to remove the spaces from your expression. It should be like below.

Sum({$<Date={"<=$(=Max(Date))"}>} QTY2)

Regards,

Sajeevan

Re: Set Analysis - Select dates less than date in selection

Wed, 09 Nov 2011 11:35:10 GMT

Hi Sajeeth/ Perumal,

I have a similar issue on this matter, what if the Date is now dynamic ?

http://community.qlik.com/thread/38695?tstart=0

Thanks so much !

Arthur

Set Analysis - Select dates less than date in selection

Wed, 09 Nov 2011 12:06:02 GMT

Thanks! It works! /Philip

Set Analysis - Select dates less than date in selection

Wed, 09 Nov 2011 12:07:32 GMT

thanks!