Alerts Via Macros

[#1]

How we can write alert script in macros...

Regards

Sikandar.

[manishkumar75 · Accepted solution]

Hi Sikandar,

Sample Macro for Alert :-

set docprop = ActiveDocument.GetProperties
set al = docprop.Alerts
al.Add
no = al.Count-1
al.Item(no).Action.Id = "AL03"
al.Item(no).Action.Message.v = "Hello world!"
al.Item(no).Comment = "New alert"
al.Item(no).Condition.AllClear = false
al.Item(no).Condition.BookmarkId = "BM01"
al.Item(no).Condition.Condition.v = "sum(Sales)>Sum(Budget)"
al.Item(no).Enabled = true
al.Item(no).Triggers.Interactive = true
al.Item(no).Triggers.OnPostReload = true
ActiveDocument.SetProperties docprop

You can take help from QlikView API guide.

- Manish

[#3]

Hi Manish

Thanx Manish.where i can find QLIKVIEW API guide?

Regards

Sikandar

[#4]

C:\Program Files\QlikView\Documentation

[#5]

Thanx Arum

Regards

Sikandar

[#6]

HI Manish

Can u send me any example qvd of urs of making alerts beacause i m having sum problems.Thanx

Regards

Sikandar

[manishkumar75]

Hi Sikandar,

Please find the sample QV Application for Alerts.

- Manish

[#8]

Hi Manish.

I have created the Alert Macro.i am having problem regarding how to apply it. My Scenario is that i have a pivot table in which their is a column of Total Sales.My Total Sale is supoose 45555.I wana do this that when i press the button object ,it must popup the alert window of saying that ur sales is this....or some thing else..It must show the alert on pressing the button object as i have seen in the alert properties ,it gives only three options regarding poping up the window.There is no option of poping up the alert window on pressing the button object.Thank u so much.

Regards

Sikandar

[manishkumar75]

Hi Sikandar,

You can specify it in Condition ( Sale > 40000) etc.

- Manish

[#10]

Hi Manish

Thanx.Manish i m describing you again my scenario ..i need to achieve this.The Script which u send me for creating a alert through macro is sucessfully

running.its creates an alert and the alert is working on opening the application ,reloading the application and when the data is reduced.But after that i

want is that the button sheet object pop up the alert window when i press the button.The alert window should popup on pressing this button sheet o

bject .I donot want the alert window be poping up on reloading the application or opening the application or when the data is reduced.I want this that

when the user press the button object the alert window has to pop up on that time not on reloading,opening or when the data is reduced.

Regards

Sikandar