topic Re: Select in Field Action - Can we pass multiple Field Names and Values? in QlikView

Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Mon, 27 Jul 2015 23:07:47 GMT

Hi All,

Can we pass multiple Field Names and their respective Field values in a Single 'Select in Field' or 'Select Possible' action of a Button?

This is a requirement I need, so that if I click on an APPLY Button, those Fields and Values get selected. But I don't want to hard-code those values in Action; those has to be passed dynamically.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

swuehl — Mon, 27 Jul 2015 23:10:35 GMT

I believe you'll need an action per field selection, but you can assign the field names dynamically ('field' is an expression entry box as well as the search string).

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Mon, 27 Jul 2015 23:11:53 GMT

Hey Swuehl,

Can you please help more here with example?

In below image, for the selection = BM01-51 , I have the Possible Values in next two List Boxes.

BookmarkFieldName has the list of Fields to be used in Select in Field/Select Possible action.

BookmarkFieldValue has the list of corresponding values to be passed in Search String.

I want to dynamically pass the BookmarkFieldName field names, whenever the Bookmark_ID value is selected.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

qlikviewwizard — Tue, 28 Jul 2015 01:30:42 GMT

Hi Try this.

Hope this will help you.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

jagan — Tue, 28 Jul 2015 03:07:58 GMT

Hi,

This is not possible normal triggers, since you have different number of fields for each bookmark. So you have use the macro with some looping and then select the values based on that. You can find some sample piece of code from

Useful Qlikview Macros

SUB SelectValues
SET Doc = ActiveDocument
fieldName = "BookmarkFieldName"
SET Field = Doc.Fields(fieldName).GetPossibleValues
FOR index = 0 to Field.Count-1
Doc.Fields(fieldName).Clear
Doc.Fields(fieldName).SELECT Field.Item(index).Text
fieldName1 = "BookmarkFieldValue"
SET Field1 = Doc.Fields(fieldName1 ).GetPossibleValues
FOR subindex = 0 to Field1.Count-1
Doc.Fields(fieldName1).SELECT Field1.Item(subindex ).Text
NEXT
Doc.Fields(fieldName).Clear
END SUB

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Tue, 28 Jul 2015 04:09:55 GMT

Hi Jagan,

Thank you for the great help here.

I applied the Macro action in the Button, but when I am clicking, only ONE possible value from BookmarkFieldName comes and ONE value is selected from BookmarkFieldValue. Image below:

Where as I need a selection set like this below:

Re: Select in Field Action - Can we pass multiple Field Names and Values?

jagan — Tue, 28 Jul 2015 05:19:58 GMT

Hi,

Attach sample file and your expected results so that it would be easier to understand and provide the solution.

Regards,

jagan.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Tue, 28 Jul 2015 14:13:18 GMT

HI Jagan,

Attach is the file and the source. Could you please support here?

I am loading all the Data from the QVD.
From the BookmarkFieldName and BookmarkFieldValue , I need the values to be used as Fields so that they can be used in Action of a Button.
Whenever the Document Name and Bookmark_ID is selected, the Possible values from BookmarkFieldName and BookmarkFieldValue are listed.

I need those possible values used as Fields and gets selected upon Clicking the Button.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

swuehl — Tue, 28 Jul 2015 19:15:50 GMT

As far as I understand, you don't want to select values in BookmarkFieldName, but use these values as field names to select in.

For example, you want to get 'Previous Month' used as field name with a selection of 'Active', right?

But your sample data does not show any field named like that...

If you just want something like shown in the second picture of your previous post, this should do:

SUB SelectValues
SET Doc = ActiveDocument
fieldName = "BookmarkFieldName"
Doc.Fields(fieldName).SELECT "*"
fieldName1 = "BookmarkFieldValue"
Doc.Fields(fieldName1).SELECT "*"
END SUB

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Tue, 28 Jul 2015 21:23:33 GMT

Hey Swuehl,

Your Macro Solution worked superb! Many Thanks.

And Your Understanding is CORRECT.

I really need those values in BookmarkFieldName and BookmarkFieldValue to be converted to Field Names and are to be selected using a Button. For example, I want to get 'Previous Month' used as field name with a selection of 'Active',
Now I have tried converting the values BookmarkFieldName and BookmarkFieldValue using Generic Load (Attached updated QVW). Now it has those fields, that you didn't find earlier.
But after the Generic Load script, the Data Model is HUGE, as it has all the Generic Tables. I have tried using the below script to Join them to main table and finally drop one by one - BUT, It takes a Long and Long time and consumes full usage of RAM, making the system dead slow. Any help here will be much helpful too

////// JOIN & DROP loop to consolidate the Generic tables

FOR i = NoOfTables()-1 to 0 STEP -1
LET vTable=TableName($(i));
IF WildMatch('$(vTable)', 'Generic.*') THEN
LEFT JOIN (BM) LOAD * RESIDENT [$(vTable)];
DROP TABLE [$(vTable)];
ENDIF
NEXT i

Once I get those values in BookmarkFieldName and BookmarkFieldValue to be converted to Field Names, I really need those Fields and Values to be selected like in screenshot below:

Re: Select in Field Action - Can we pass multiple Field Names and Values?

swuehl — Tue, 28 Jul 2015 22:33:42 GMT

Maybe like this.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Wed, 29 Jul 2015 01:02:44 GMT

Thank you Swuehl,

This works wonder... Got the concept! Many thanks again. Marking this thread as correct.

By any means can you help here in dropping all the Generic Tables after the Join????

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Wed, 29 Jul 2015 01:07:28 GMT

Hi Jagan,

Many thanks to you for the help here in Macro. swuehl has helped here in achieving the desired results.

Also, you are free to take the latest attached app and play around for some alternatives and ideas.

I have used a Generic Load concept to convert all the Field Values to Columns/Fields. Now I also have a script to Join them and Drop the tables, but that's taking a lot of time and RAM.

Any suggestions please?

Re: Select in Field Action - Can we pass multiple Field Names and Values?

jagan — Thu, 30 Jul 2015 04:13:37 GMT

Hi Mohanty,

It takes time if you have huge data, what swuehl has given is the correct one.

Regards,

Jagan.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Wed, 05 Aug 2015 13:06:46 GMT

Hi swuehl‌ and jagan‌,

I just came back to this post for some more help here -

When I launch the app in AJAX mode in Access Point or simply Turn On the Web View, and then Click on the Button, it does not work. Probably the Macro is not working in AJAX.
Any possible/futher help here please?

Regards!!

Re: Select in Field Action - Can we pass multiple Field Names and Values?

jagan — Wed, 05 Aug 2015 14:42:02 GMT

Most of the macros won't work in Ajax mode. Try using the Select In Field triggers for this.

Regards,

Jagan.

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Wed, 05 Aug 2015 14:50:09 GMT

Hi jagan,

Thanks. I was thinking of the same to try.

Could you please show me a sample? Do I need to remove all that Macro?

Re: Select in Field Action - Can we pass multiple Field Names and Values?

dmohanty — Tue, 15 Sep 2015 16:31:28 GMT

Hey jagan‌ and swuehl‌,

This has worked in the Access Point from AJAX mode perfectly.

Here wanted one quick suggestions please -

Is it possible for change this VBScript code to JScript somehow?