Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Macro for selecting possible value

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.

16 Replies
gandalfgray
Specialist II
Specialist II

Thanks for pointing that out to me!

Yes there is:

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

selectpossiblebyaction.JPG

Not applicable
Author

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!

Not applicable
Author

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

Thanks!

Not applicable
Author

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..

Not applicable
Author

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?

farolito20
Contributor III
Contributor III

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

Not applicable
Author

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

next

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 ?