Calculating Intervals

Thu, 10 Oct 2013 16:04:23 GMT

Hi, I have a list with 'Item Number' and 'Date Sale'.

Item	Date
Item 03	13/08/2013
Item 06	12/08/2013
Item 05	11/08/2013
Item 09	10/08/2013
Item 01	15/07/2013
Item 03	05/07/2013

First, I calculate the interval in days between any date write by the user and the 'Date Sale'. If the user write the date (dd/mm/yyyy) 10/10/2013, then:

Item	Date	Interval (days)
Item 03	13/08/2013	58
Item 06	12/08/2013	59
Item 05	11/08/2013	60
Item 09	10/08/2013	61
Item 01	15/07/2013	87
Item 03	05/07/2013	97

But instead the interval number, I show a label:

'1-29 Days'

'30-59 Days'

'60-89 Days'

'>= 90 Days'

Item	Date	Interval
Item 03	13/08/2013	30-59 days
Item 06	12/08/2013	30-59 days
Item 05	11/08/2013	60-89 Days
Item 09	10/08/2013	60-89 Days
Item 01	15/07/2013	60-89 Days
Item 03	05/07/2013	>= 90 Days

And (this is the problem) I need to select which interval to show, by example only show the Items with interval '>= 90 days' or intervals '1-29 Days' and '60-89 Days'. Remember that the user can write any date.

Attached a sample file, thanks.

Re: Calculating Intervals

swuehl — Thu, 10 Oct 2013 16:14:30 GMT

Maybe like attached?

Re: Calculating Intervals

Thu, 10 Oct 2013 17:14:13 GMT

Yes sir !! Thank you very much.

Re: Calculating Intervals

preminqlik — Thu, 10 Oct 2013 18:13:30 GMT

hi javier florez....

using class function we can do this....am attaching soln as per your example ...PFA

topic Re: Calculating Intervals in QlikView

Calculating Intervals

Re: Calculating Intervals

Re: Calculating Intervals

Re: Calculating Intervals