topic Re: current dat on active sheet in QlikView

current dat on active sheet

Anonymous — Thu, 14 Feb 2013 05:21:18 GMT

hi,

i have feild with date, what i need to write in the trigers that every time that i open that sheet

i will see the current day.

i need to do it on the "sheet properteis"?

thnaks'

yarin.

sushil353 — Thu, 14 Feb 2013 05:38:02 GMT

Hi,

goto Settings>Document Property>Triggers>Document Event Triggers>On Open>Add Action> Action Type(Selection)> Action(Select in field)

Select your date field in field box and in search string =Max(Date_field).

HTH

Sushil

Anonymous — Thu, 14 Feb 2013 06:16:32 GMT

hi,

i did what you wrote & it doesn't change the date when i go into that sheet.

you have any idea ?

thanks'

yarin.

sushil353 — Thu, 14 Feb 2013 06:56:21 GMT

can u share the sample qvw file

sushil353 — Thu, 14 Feb 2013 07:01:43 GMT

do u want to trigger the date selection whenever u activate the sheet?

if yes then

goto Settings>sheet property> On activate sheet>add action

add action as i told u in the previous post

khadeer — Thu, 14 Feb 2013 07:10:01 GMT

Document Properties--->Triggers---->On Open Selections

For Sheet do the same in goto Settings>sheet properties> On activate sheet>add action

Check attached file. Its working for me.

khadeer — Thu, 14 Feb 2013 07:30:12 GMT

Check this updated file

Thu, 14 Feb 2013 12:24:05 GMT

You can achive this by using macro onActivateSheet Trigger.

Following is the code to achive your requirement, Hope this will help you,

set sheet=ActiveDocument.ActiveSheet

set sp=sheet.GetProperties

sp.Name= WeekDayName(WeekDay(date))

sheet.SetProperties sp