topic Messagebox in QlikView

Messagebox

Thu, 12 Apr 2012 12:08:57 GMT

Hey,

Ive got another question :

I'm using Qlikview 10 and i'm writing a macro which generates charts in excel and pdf files.

I'm showing a messagebox in my macro but i want that the messagebox dissapears in 5 seconds

if nobody clicks on the button "OK".

I tried :

WsShell.Popup("Loading charts", _

'5)

ActiveDocument.GetApplication.WaitForIdle 5000

I just want the script to wait a few seconds so it can generate my charts, if not i get a white rectangle instead of a chart.

If i work with a messagebox and i click on "OK" it generates my charts.

So any suggestions to make this work?

If you don't understand my question feel free to ask

Hope someone can help me

Messagebox

Anonymous — Thu, 12 Apr 2012 13:07:20 GMT

I Try out to find the solution for your problem and i got the solution .

But this script's will be working only in the Macro Debug mode(Click Debug button from Macro Edit Module and

check).

Solution 1:

Sub MessageBox

Set oWScript = CreateObject("WScript.Shell")

For i = 1 to 1

oWscript.popup "Hi" ,1

Set oWScript = nothing

End Sub

Solution 2:

Sub Messagebox

CreateObject("WScript.Shell").Popup "Hello", 2, ""

End Sub

Just copy and paste it your qlikview and create one macro button with the name of Messagebox and click the

debug button from edit module macro.

Then you will understand the problem in qlikview application .

Regards

Ashok.

Messagebox

Thu, 12 Apr 2012 14:09:56 GMT

Thx for the quick respons

I already tried those solutions but i only get a messagebox/Popupbox but it wont dissappear

(only if i click the OK button)

Messagebox

Anonymous — Thu, 12 Apr 2012 14:28:07 GMT

I hope is this not possible to close the message box based on the time period in qlikview application.

Redards

Ashok

Messagebox

CELAMBARASAN — Thu, 12 Apr 2012 14:38:28 GMT

Hi,

You can have try by creating the Text object with ok and cancel button over it and set variable value in that button.

Show and hide those objects using macro based on time(using conditional option of those objects with a variable name)

Celambarasan

Messagebox

Thu, 12 Apr 2012 14:41:39 GMT

so you mean that it isnt possible to close the messagebox automatically after a time period?

and why is the

ActiveDocument.GetApplication.WaitForIdle

not working?

Because my macro has to wait a bit before qlikview generates the charts.

I tried,

Sleep

wait

etc..

Nothing helped,

only if i put a messagebox in my script and if i click "OK" the chart is generated correctly.

But because its a macro who needs to run at night without userhelp, i can't use that messagebox

Regards

Quintenl

Messagebox

Thu, 12 Apr 2012 14:46:48 GMT

i don't understand what you mean

can you give an example or code?

Thx!

Messagebox

CELAMBARASAN — Thu, 12 Apr 2012 14:55:11 GMT

Hi,

Did you tried with

ActiveDocument.GetApplication.Sleep 10000

Messagebox

Thu, 12 Apr 2012 14:59:49 GMT

Yes,

The application waits then but after that time the application generates

the charts in excel, but we only get a blank(white) chart.

And when we use the button and click "OK" we got the real chart

Messagebox

CELAMBARASAN — Thu, 12 Apr 2012 15:04:43 GMT

Hi,

Then try using this sleep function without that msg box

Function Sleep(seconds)

elapsed = TimeSerial(0,0,seconds)

startTime = Time()

endTime = TimeValue(startTime) + TimeValue(elapsed)

While endTime > Time()

Wend

End Function

Celambarasan

Messagebox

Fri, 13 Apr 2012 12:58:46 GMT

thx for the answers,

i tried it but it doesnt work

is this some sort of bug of qv10 that the time function doesnt work?

Messagebox

Fri, 13 Apr 2012 14:29:19 GMT

what do you mean exactly that it doesn't work? It waits forever? It doesn't wait at all?

Messagebox

erichshiino — Fri, 13 Apr 2012 15:18:47 GMT

hi,

Instead of a Windows popup, you can use a QV popup.

Please, check my answer to this post:

http://community.qlik.com/message/119292#119292

hope this helps,

Erich

Messagebox

Mon, 16 Apr 2012 09:09:35 GMT

Yep, that works for normal charts but the boxplot charts still don't get pasted on the excel sheet,

still got a white rectangle instead of a boxplot chart even if i wait 50seconds.

Did someone have already been able to export a chart (boxplot) via vb scripting to excel?