topic calander object in QlikView

calander object

Anonymous — Wed, 24 Nov 2010 08:48:35 GMT

Hi,

I am using two calander object in my application. in that one is for FROM DATE and other is for TO DATE, all my calculations are based on the FROM and TO Calander object. Now i wants to restrict calander object in such a way that FROM DATE should not greater then TODATE and TO DATE is not less then FROM DATE. At the time of selecting the date this needs to be validated.

Can Any one provied me help to this in qlikview 9 SR5

calander object

deepakk — Wed, 24 Nov 2010 10:13:28 GMT

In Case of From Date..

Set MAx valueof Fromdate claendar as = Max(ToDate) ---- where Todate is the variable.

In Case of To Date

set Min Date of To Date Calendar as Min(FromDate)--- where from date is the variable..

I hope this helps you out.

calander object

Wed, 24 Nov 2010 10:35:56 GMT

Hi,

I think you should use Field Event Triggers. settings --> Document properties --> Triggers --> select "TODATE" or "FROMDATE" to add or edit an OnSelect - Action. In this trigger you can code i.e. some dependencies as you descriped.

EXAMPLE:

a) action is "select on field"

b) field is "TODATE"

c) expression similar to: date(rangemax( getfieldselections(FROMDATE), max(FROMDATE) ))

Regards, Roland