topic Re: Macro script: Count current selected values in field in QlikView

Macro script: Count current selected values in field

Mon, 10 Aug 2015 15:06:44 GMT

I'm currently using a macro with an if statement that goes like this:

if ActiveDocument.Fields("%VIEW_NAME").GetSelectedValues.count > 0 then

ActiveDocument.Fields("PB_User_Flag").Lock

ActiveDocument.Fields("MASTER_ID").Lock

end if

Yet, when the macro is triggered, the above fields are not locking. Any insights??

Re: Macro script: Count current selected values in field

Anonymous — Mon, 10 Aug 2015 15:15:30 GMT

the condition is true? did you try msgbox to test?

the Syntax Looks good. I made a small example (without condition ) and the field is locked

Re: Macro script: Count current selected values in field

Mon, 10 Aug 2015 15:28:07 GMT

If i test with a text box in the dashboard GetSelectedCount(%VIEW_NAME), the result is 1. But when I test with a msgbox in the macro script, nothing appears. Not sure what is missing here.

Re: Macro script: Count current selected values in field

Anonymous — Mon, 10 Aug 2015 15:32:35 GMT

try as first Expression in macro

what is the result? if not 1 then check your field

msgbox ActiveDocument.Fields(("%VIEW_NAME").).GetSelectedValues.count

I tested with same condition and for me it works!

Re: Macro script: Count current selected values in field

Mon, 10 Aug 2015 16:25:09 GMT

Very strange, the message box comes up as 1, but then nothing locks.

Re: Macro script: Count current selected values in field

Anonymous — Mon, 10 Aug 2015 16:53:15 GMT

can you lock the fields with button "lock"?

Re: Macro script: Count current selected values in field

marcus_sommer — Tue, 11 Aug 2015 10:37:03 GMT

I think you need to create at first an object and could then query the count:

dim doc, myField

doc = ActiveDocument

set myField = doc.GetSelectedValues

' msgbox myField.count 'optional for check

if myField.count > 0 then

doc.Fields("PB_User_Flag").Lock

doc.Fields("MASTER_ID").Lock

end if

- Marcus

Re: Macro script: Count current selected values in field

rubenmarin — Tue, 11 Aug 2015 11:34:55 GMT

Hi, If you set the lock otuside the If(), it works?