creating from an additionally flag-field to exclude such future data

[Anonymous]

How to create from an additionally flag-field to exclude such future data which are forecast-data by selecting (and locking) this field ?

[Anonymous]

Not sure what you are asking ?

Do you want to exclude data after today ?

[Anonymous]

yes exact

[Anonymous]

In the script maybe something like :

     If ( [YourDate} > today() , 'Yes' , 'No' )     as [Future Flag] ,

[marcus_sommer]

Within your load (best within the master-calendar) create a new field which is checking your date-field with:

...

if(date < today(), dual('past', 0), dual('future', 1)) as DateFutureFlag,

....

- Marcus

[Anonymous]

how can I use this flag in the filter ?

[Anonymous]

Create a List Box on the Flag Field and select the value you are after.

[marcus_sommer]

Like Bill mentioned use a simple listbox and if you hide them (directly or on a hiden sheet) and lock them those selection couldn't be easy deselect from any other user-selection.

- Marcus

[Anonymous]

I didn't figure out , I am newbie with QV

[Anonymous]

Do you know how to create a List Box ?