topic Default Values in QlikView

Default Values

Dayna — Fri, 23 Oct 2009 19:57:23 GMT

Hello All,

Should be a very easy one ....

How do you set a default value on load of an application for a) variable and b) field.

i.e.A) date variable to be set to the minimum value of a datefield and..

B) a field to be set to a specific customer...

Kind Regards,
Dayna

Default Values

Fri, 23 Oct 2009 20:10:01 GMT

Variable

set vb_Date = '22.10.2009'

Field

TableSales:

LOAD

Field1,

Field2,

'Active' as [Custoemr Status]

Default Values

Fri, 23 Oct 2009 20:32:21 GMT

a field to be set to a specific customer...

Sub Partenza
'Select the current year
ActiveDocument.GetField("AnnoSel").Select ActiveDocument.Evaluate("year(today())")
'Select the current month
mese = right("0"&ActiveDocument.Evaluate("Num(month(today()))"),2)
ActiveDocument.GetField("MeseSel").Select ActiveDocument.Evaluate(mese)
end sub

Daniela