topic Macro for selecting possible value in QlikView

Macro for selecting possible value

Fri, 06 May 2011 07:22:34 GMT

Hi!

In my macro I want to automaticaly select a possible value depending on antoher value (obviously) that i've selected manually.

Is this possbile?

Thanks!

//A.

Macro for selecting possible value

montubhardwaj — Fri, 06 May 2011 07:55:50 GMT

Why going for MAcros? you can easily achieve it through Triggers/Actions

Macro for selecting possible value

gandalfgray — Fri, 06 May 2011 07:58:57 GMT

Hi Annika

You can select all possible values in a field like this:

ActiveDocument.Fields("Month").SelectPossible

If you want to select matching a specific search value:

ActiveDocument.Fields("Month").Select "September"

(selects September)

ActiveDocument.Fields("Month").Select "J*"

(selects January, June, July)

ActiveDocument.Fields("Sales").Select ">1500"

(selects all Sales larger than 1500)

hope this helps!

Macro for selecting possible value

Fri, 06 May 2011 14:49:48 GMT

You're both right!

Thank you for your help!

😃

Macro for selecting possible value

IAMDV — Fri, 06 May 2011 14:55:05 GMT

Have you considered using Indirect Set Analysis, which is more faster than macros & triggers.

• p( ) = Possible

• e( ) = Excluded

Example

sum(({<Year={$(=max(Year))},

Customer = p({<Year={$(=max(Year)-1)} Customer>}) Sales)

Cheers - DV

Re: Macro for selecting possible value

Thu, 16 Jun 2011 05:12:18 GMT

Hi GandalfGray,

I have a similar kind of a requirement.Tried to iimplement whatever you have told but to no effect

Could you please elobarate on the Macro whatever you have mentioned.Should I take the

possible values into a variable.

Regards

Navin Gorapalli

Re: Macro for selecting possible value

gandalfgray — Thu, 16 Jun 2011 08:25:09 GMT

This is how a subroutine to select the possible values in the field "Month" could be written:

sub SelectPossibleInMonth()

ActiveDocument.Fields("Month").SelectPossible

end sub

then you obviously must call the macro whenever you want

You don't need any variables.

ActiveDocument.Fields("Month") specifies that its your field "Month" that the SelectPossible should be applied for.

Re: Macro for selecting possible value

Wed, 17 Aug 2011 15:34:36 GMT

Can you shed a little insight on how to accomplish this via and Action? Thanks!

Re: Macro for selecting possible value

gandalfgray — Thu, 18 Aug 2011 06:16:12 GMT

Of course!

See the attached application, where possible colors are selected based on which fruit(s) are selected when the button is activated!

Re: Macro for selecting possible value

Thu, 18 Aug 2011 12:29:05 GMT

Ahh, I'm sorry - I thought there was a way to do it without a macro. This will work for m, but I thought Macros were deprecated?

Macro for selecting possible value

gandalfgray — Thu, 18 Aug 2011 13:49:17 GMT

Thanks for pointing that out to me!

Yes there is:

Just add a "Select Possible" action and specify which field:

Macro for selecting possible value

Thu, 18 Aug 2011 14:08:39 GMT

Ok, so here's the rub - I am trying to select in a table that does not have a join. So:

Table A has a column "Table.EmployeeID", and Table B has a column "TableB.LoginID" - the tables are data islands, with no joins.

I want to be able to select a record in TableA, then click a button and have the matching records in TableB selected.

orry for hijacking the thread!

Re: Macro for selecting possible value

Thu, 18 Aug 2011 14:18:05 GMT

Nevermind, I see that I can just do "Select in Field" coupled with" GetFieldSelections" (since this will only ever have one record selected)

Thanks!

Macro for selecting possible value

Tue, 08 Nov 2011 16:42:10 GMT

Macro didn't work for me with Ajax.

Using Select Possible Action I can only select one value but the moment I clear the selection it get cleared.

Is there a solution where I can trigger an action to trigger 'Always one Selected Value' which should work even when I reload with no data?

Thanks..

Re: Macro for selecting possible value

Tue, 05 Jun 2012 11:58:02 GMT

Dear all,

Triggers like On Open are not working when qvw files are viewd through Access Point. I am using Qlikview 11.

To anybody's wonder, behaviour of triggers is weird. Sometimes they work or sometimes they dont work.

I checked out all possible scenarios but the problem exists ONLY ON Access Point and not on desktop client.

What may be the problem?

Re: Macro for selecting possible value

farolito20 — Wed, 09 Jan 2013 22:45:36 GMT

Do you know how Load data in macro from qvd files?

Re: Macro for selecting possible value

Mon, 29 Dec 2014 10:42:19 GMT

Hi,

I am trying to make a a selection from a list box which has an expression in it.

I generally use the below syntax to select values from list box:-

listbox3=Array("<value>")

Set Qv = CreateObject("QlikTech.QlikView")

Set QvDoc = Qv.OpenDoc("<QV_File_location>")

QvDoc.GetSheetObject("<objectID")

Set fz = QvDoc.Fields("objectname")

for each v in listbox3

fz.ToggleSelect v

But whenever I try to access an expression from a list box, it will have an objectID but wont have an object name ? How can I solve for this problem ?