topic Re: Calendar Input Box in QlikView

Calendar Input Box

Wed, 20 Mar 2013 09:49:53 GMT

Hi All,

I need to make a chart counting the no. of records that is outstading based on the calendar input box.

I want the chart looks like this:

the formula

= date input - Shipmentdate

current = <0

1-30days = >0<=30

Over 30days = >30<=60

.. and so on

Please see attached file.

Thanks

Gysbert_Wassenaar — Wed, 20 Mar 2013 10:27:17 GMT

See attached qvw. Is that what you need?

Thu, 21 Mar 2013 00:59:12 GMT

Yes, Just like that! But I need it to be fix 'Over 240 Days' Is there any way for that to be implemented? Thanks

Gysbert_Wassenaar — Thu, 21 Mar 2013 08:26:24 GMT

Change the calculated dimension to:

=if(vDate-ShipmentDate<0,dual('Current',-1), if(vDate-ShipmentDate<240 ,class(vDate-ShipmentDate,30),dual('Over 240 days',9999)))

Thu, 21 Mar 2013 08:42:57 GMT

Hello, Thanks for the reply.

Another question please, I need it to be 1< x <= 30 because current is already counted as 0, is this possible to be achieved?

Gysbert_Wassenaar — Thu, 21 Mar 2013 09:28:04 GMT

=if(vDate-ShipmentDate<=0,dual('Current',-1), if(vDate-ShipmentDate<=240 ,class(vDate-ShipmentDate,30,'days',1),dual('Over 240 days',9999) ))

Fri, 22 Mar 2013 00:36:22 GMT

Thank you!