Display Message Box

[jagannalla]

Hi,

- I want to display a message box in the sheet while data is loading into the reports.

How can i do this. Is possible to do this?

[Denis_Brajkovic]

You could use the built in functionality in Qlikview:

Settings -> Document Settings -> Server

and elaborate with the settings there. I persume the general purpose is to inform the users that a new copy is available with fresh data. If that is the case then that would be good enough.

[neetu_singh]

Hi,

you can write the code at script i.e.

Load

MsgBox

('Message 2', 'msgbox', 'OKCANCEL', 'ICONASTERISK') as x, 2 as r

autogenerate

Regards

Neetu SIngh

1;

[jagannalla]

I want to display message box at accesspoint..I mean in web browsers

[#5]

I want to display vRunTime  as message box , Kindly let me know how can i do this

LET vStart = num(now());

Store * from  tempqvd into tempqvd.qvd (qvd) ;

LET vRunTime = interval(now() - $(vStart),'mm:ss');

[#6]

i am having a code which i am going to write .

1. i am loading at the script and

2 showing the completed time at the vbscript message box.

here is my peace of code.Can any one of you help me out on this.

QV Script

lET vStart = num(now());

Store * from  FactTemp into FactTemp.qvd (qvd) ;

LET vRunTime = interval(now() - $(vStart),'mm:ss');

call alp(vRunTime) ;

VB Macro

function alp(vRunTime)

msgbox vRunTime;

end function

[jagan]

Hi,

Try like this

lET vStart = num(now());
LET vRunTime = interval(now() - $(vStart),'mm:ss');

Test:
Load
MsgBox('$(vRunTime)', 'msgbox', 'OKCANCEL', 'ICONASTERISK') as x
autogenerate 1;

DROP TABLE Test;

Regards,

Jagan.

[#8]

Jagan Mohan

Thanks Jagan It's working Fine.

[#9]

Thanks Jagan It's working fine Regards Srini

[#10]

First of all you need to add the Message Box extension object to each sheet you want Messages to display in.  To do this you need to be in Web View,

Right click on a blank area of the sheet to get the menu and select New Sheet Object.

On the New Sheet Object menu, select the sub menu Extension Objects

Click and hold Msg Box and drag it onto the sheet.

Right click over top of the Msg Box object to edit properties - here you will be able to design and position it.

You are NOT able to design or position it in standard normal design view - it corrupts the object and turns it into a bar chart for some odd reason.

To populate the message box - many people here have already detailed the macro's etc necessary to do that.

Hope this helps!

DD