calander object

[Anonymous]

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

[deepakk]

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.

[#3]

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