topic Disappearing button object in QlikView

Disappearing button object

kim_rormark — Tue, 09 Aug 2011 08:01:47 GMT

Hi,

Have anyone noticed button objects disappearing in your QV application? I don't know when/why this happends, but I have five buttons on one sheet, and I had to recreate one of them a couple of days ago, and now another one is missing. They are not minimized (I think), because they are not allowed to.

QV version 10 SR3.

Any suggestions?

Disappearing button object

sushil353 — Tue, 09 Aug 2011 08:06:17 GMT

Have you checked the objects in the document/sheet property tab... just check it whether they were there in the list or not..

Thanks

sushil

HTH

Disappearing button object

kim_rormark — Tue, 09 Aug 2011 08:09:52 GMT

I was looking for some list like that, so I didn't check until now.

No, there are only 4 button objects there, whereas there use to be five. I did not close the document, only did some reloads, then I noticed the button had disappeared. The first time I thought i was just something I did wrong, but I know I have not moved or removed it this time.

Disappearing button object

sushil353 — Tue, 09 Aug 2011 08:14:57 GMT

can you please specify what kind of button had been removed... are they linked to a perticular action... please be little bit more clear about the problem.

Disappearing button object

kim_rormark — Tue, 09 Aug 2011 08:19:58 GMT

Hi,

I'm sorry if I was not clear enough. The button was a standard "Button" added from the "sheet right-click menu > New Sheet Object > Button...". The button was linked to a macro that empties some variables (sets them to ""). The first button was linked to a macro that saved some information from variables to access DB.

If you need some more information, please ask!

Disappearing button object

erichshiino — Tue, 09 Aug 2011 10:56:00 GMT

Hi,

Check if you button is not going behind another object.

You can set it to be on a top layer going to:

button properties-> Layout -> layer -> select 'Top'

Hope this helps,

Erich

Disappearing button object

kim_rormark — Tue, 09 Aug 2011 10:58:36 GMT

Hi,

That I already did. But as I wrote in my last reply, the button object is also gone from objects list in the sheet properties, so it is totally gone. Am I an isolated case?

Disappearing button object

m_woolf — Tue, 09 Aug 2011 12:06:08 GMT

You might post the macro code that the button runs.

You might also post your qvw for our examination.

Re: Disappearing button object

kim_rormark — Tue, 09 Aug 2011 12:09:46 GMT

Hi,

This is the macro-code the button runs:

Sub ClearInc
varClear = ""
ActiveDocument.Variables("ibvIncRegBy").SetContent varClear, true
ActiveDocument.Variables("ibvIncGrouping").SetContent varClear, true
ActiveDocument.Variables("ibvIncCustomerCode").SetContent varClear, true
ActiveDocument.Variables("ibvIncDateStart").SetContent varClear, true
ActiveDocument.Variables("ibvIncTimeStart").SetContent varClear, true
ActiveDocument.Variables("ibvIncDateEnd").SetContent varClear, true
ActiveDocument.Variables("ibvIncTimeEnd").SetContent varClear, true
ActiveDocument.Variables("ibvIncType").SetContent varClear, true
ActiveDocument.Variables("ibvIncDescription").SetContent varClear, true
ActiveDocument.Variables("ibvIncIMnr").SetContent varClear, true
End Sub

I cannot post the entire qvw, sorry. I hope this helps though. I appreciate all and any help!

Re: Disappearing button object

m_woolf — Tue, 09 Aug 2011 12:13:22 GMT

Do any of these variables have actions for their event triggers?

Re: Disappearing button object

kim_rormark — Tue, 09 Aug 2011 12:16:40 GMT

No, they do not have actions for their event triggers, but some of them do have constraints defined in an InputBox.

Re: Disappearing button object

m_woolf — Tue, 09 Aug 2011 12:20:40 GMT

Have you check other sheets in the qvw to see if the buttons accidentally moved?

You could always got to sheet properties|Security and not allow Remove sheet objects.

Re: Disappearing button object

kim_rormark — Tue, 09 Aug 2011 12:25:36 GMT

The button does not exist in any sheet, I looked in the Document Properties > Sheets > Objects.

I will not say 100% sure that I did not do this by a mistake, so I just remake the button and see if it happends again. One possible reason might be that I have two buttons with the same title, but I won't think that is likely.

Thanks for all help, you will hear from me if it happends again.