topic Problem in macro in QlikView

Problem in macro

Tue, 31 Aug 2010 15:21:23 GMT

Hi,

Im using a macro to set 'Always one selected' Property for a listbox.

For eg: 'Currency' Field

In one Tab, 'Currency' Field should have default selection as 'Euro' and the same field should be cleared in another sheet (No value selected).

It was working in my development environment , But not in the accesspoint. Please let me clear what may be the problem

Im using the following macro:

Sub Select
ActiveDocument.Fields("Currency").Select "EURO"
set fld1 = ActiveDocument.GetField("Currency")
set fprop1 = fld1.GetProperties
fprop1.OneAndOnlyOne = true
fld1.SetProperties fprop1
End Sub

Sub Clear
set fld = ActiveDocument.GetField("Currency")
set fprop = fld.GetProperties
fprop.OneAndOnlyOne = False
fld.SetProperties fprop
ActiveDocument.ClearAll
End Sub

First macro in one sheet , for the default selection and second one for clearing the macro

It was not working in the accesspoint

Can anyone help me in this? where Im doing wrong...

Thanks in advance,

Dhoulath

Re: Problem in macro

ipauldur — Thu, 21 Jul 2011 03:48:34 GMT

Hi,

I am facing the same issue. Did u get solution for this?.

Please share with me.

Thanks,

Durai.

Problem in macro

Thu, 21 Jul 2011 06:07:21 GMT

Have you enabled macros while it was asking you to enable it first time.

Whenever there is macros in file, at client it asks to enable macros. Enable all macros.

Hope it will help you.

Problem in macro

qliksus — Thu, 21 Jul 2011 06:10:26 GMT

If u read the Limitaion of Using macro in Server it is mentioned that the macro will not work when u call it on

activation of sheet

Re: Problem in macro

ipauldur — Thu, 21 Jul 2011 07:15:58 GMT

Hi,

I enabled macros. Actually, its working fine on Qv9 version. Recently we have upgraded to Qv10Sr3 version. After that only, its not supporting. Even if you trigger the macro through button also not working. In the same application all macros are working fine when we open in desktop version. The issue is happening when we access the app from server. Especially the "AlwaysOneSelected Value" is not happening.

Thanks,

Durai.

Problem in macro

Wed, 17 Aug 2011 11:27:28 GMT

Seems to be a problem in QV10 SR3. We have the same system environment and OneAndOnlyOne = true is not working - even if i put it on a button.

Problem in macro

kaushiknsolanki — Wed, 17 Aug 2011 11:48:21 GMT

Hi,

If you look at the API it is been stated that whenever you use the "OneAndOnlyOne" property, that must be used with ShowAlternative property.

Here is the sample code.

set fld=ActiveDocument.GetField("Class")

if fld.GetValueCount(1) = 1 then

set fprop = fld.GetProperties

fprop.ShowAlternatives = false

fprop.OneAndOnlyOne = true

fld.SetProperties fprop

end if

Regards,

Kaushik Solanki

Problem in macro

Fri, 19 Aug 2011 06:45:25 GMT

Hi Kaushik,

thanks for your answer. I tried to work with your idea, but the macro still is not working. The only difference between using ShowAlternative or not is, that all not selected values are marked yellow. But you still can markup more than one value or markup no value (even if OneandOnly is set to true).

Regards, Martin

Problem in macro

Fri, 20 Jan 2012 14:08:47 GMT

Is there a solution for this bug in QV10 SR4 or in QV11?

Problem in macro

Fri, 03 Feb 2012 12:02:32 GMT

I have the same problem. It works fine in the desktop environtment, but it doesn't work in the accesspoint.

What I have discovered is that when you save the document from the desktop be sure that the "oneandonlyone" property is set to false. If you set the "oneandonlyone" property to true and you save the document, then you are not able to change the property with a macro in the accesspoint.

Re: Problem in macro

phersan_sme — Fri, 03 Feb 2012 15:47:32 GMT

Same issue here on QV10 SR4... just found a workaround that seems to work for me in AJAX and Desktop client.

BEFORE, I was using this code (slightly modified) from the APIGuide and it would not work on document OnOpen or a Button or any other trigger, but it works fine in Desktop client:

'Selects first value of Dim1

set fld = ActiveDocument.GetField("Dim1")

fld.TopSelect "MaxString(Dim1)", 1

'Sets "Always One Selected" property for Dim1

if fld.GetValueCount(1) = 1 then

set fprop = fld.GetProperties

fprop.ShowAlternatives = false

fprop.OneAndOnlyOne = true

fld.SetProperties fprop

end if

Apparently, my QV Server 10SR4 wasn't picking up my IFieldProperties object and something was breaking in the SetProperties, I assume.

NOW, I changed my code to this and it seems to be working fine with any trigger:

'Selects the first value in Dim1

set fld = ActiveDocument.GetField(Dim1)

fld.TopSelect "MaxString({1} Dim1)", 1

'Sets "Always One Selected" property

if fld.GetValueCount(1) = 1 then

fld.GetProperties.OneAndOnlyOne = true

fld.GetProperties.ShowAlternatives = false

end if

Things seem to be working now. Has anyone confirmed this with QlikView as a bug? Is something going on with their IFieldProperties object or the Field.SetProperties command?

Let me know if this solves your issues. Attaching QVW as sample.

EDIT: this works for me, but has not worked for a co-worker.

Re: Problem in macro

hugmarcel — Thu, 08 Nov 2018 11:09:31 GMT

This is not working for me in QV 12. SR5.

It "seems" to work as long as if you are using "Classic" for listbox presentation.

If you switch presentation to checkboxes, you will probably find that multiple values are beeing selected when a additional value is being selected.

Regards - Marcel