topic Add an Action to a Sheet in QlikView

Add an Action to a Sheet

darrellbutler — Fri, 25 Mar 2011 11:55:46 GMT

Hi,

I'm trying to add an action to a sheet that only displays data for the current month to date when you open it.

I have created two variables, one tells us the current yer and month the other the day of the month.

My first action works fine where

MonthYear =vMaxMonthYr

For my second action I want to display Day <=vDaysSoFar. (vDaysSoFar is a number, for 25/03/11 it reads 25)

However the second action is getting ignored.

Does anybody have any ideas how to get round this.

My MonthYear & Day are all based on a date in dd/mm/yyyy 00:00:00 format, I think this may be linked to my issue.

Any help greatly received !

Miguel_Angel_Baeyens — Fri, 25 Mar 2011 12:07:32 GMT

Hello,

What does your variable vDaysSoFar store? Are you using the action "Select in Field"?

Regards.

darrellbutler — Fri, 25 Mar 2011 12:13:05 GMT

Hi,

vDaysSoFar is a number representing todays date i.e 25 for the 25/3, and yes I'm using the select in field action.

many thanks

Fri, 25 Mar 2011 12:18:37 GMT

Hi FirstMilk ,

what do u want exactly.. do u want to add an action to sheet or document.

Add actiond to Sheet:

do right clik on the sheet name(right clik on the tab) and clik sheet properties and now goto Triggers tab and

find, Sheet Event Triggers, OnActive Sheet, clik Add Actions.. Button

now add action what u want.

Add action to Document:

Goto Setting tab-> Documment Properties -> Triggers tab -> Document Event Triggers -> select Onopen and add action what u want.

the above actions are being performed, when u open sheet or open your Qlikview Document respectively..