topic Re: Display Message Box in QlikView

Display Message Box

jagannalla — Fri, 29 Apr 2011 11:23:12 GMT

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?

Display Message Box

Denis_Brajkovic — Fri, 29 Apr 2011 12:32:44 GMT

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.

Display Message Box

neetu_singh — Fri, 29 Apr 2011 13:00:18 GMT

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

Display Message Box

jagannalla — Fri, 29 Apr 2011 13:25:10 GMT

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

Re: Display Message Box

Fri, 23 Aug 2013 05:49:06 GMT

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');

Re: Display Message Box

Mon, 26 Aug 2013 04:30:26 GMT

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

Re: Display Message Box

jagan — Mon, 26 Aug 2013 05:26:15 GMT

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.

Re: Display Message Box

Mon, 26 Aug 2013 05:46:17 GMT

Jagan Mohan

Thanks Jagan It's working Fine.

Re: Display Message Box

Mon, 26 Aug 2013 05:47:24 GMT

Thanks Jagan It's working fine Regards Srini

Re: Display Message Box

Fri, 14 Mar 2014 14:18:34 GMT

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!