topic Re: tag fields using mapping table in QlikView

tag fields using mapping table

fineasfalco — Fri, 16 Nov 2018 15:40:22 GMT

dear community,

I have the following scripting code:

TABLE_Tag:
mapping LOAD * inline [
MyField,MyTag
'Material Number','$hidden'
Plant, '$hidden'
];
tag fields using PROREP_Tag;

The instructions consent to hide the fields Material Code and Plant, in Current Selection box.

II have the necessity to show the fields hidden without reload the script

The instruction "Untag fields using TABLE_Tag;" restore the field visualization (within loading script), but I want change dynamically the association field -> tag, without to reload the script.

Could you help to me to identify a method?

Thank you very much for your support.

Regards

Fineas

Re: tag fields using mapping table

marcus_malinow — Fri, 16 Nov 2018 15:59:22 GMT

Unfortunately there's no way to adjust the hidden tag apart from through the reload script.

If the issue here is time taken to load your data model, you might use a binary load, then apply your tags

Re: tag fields using mapping table

fineasfalco — Fri, 16 Nov 2018 16:38:23 GMT

Tks Markus,
I need to modify the showed fields in the current selection box,
I have different sheets in the document and I want to show the selected items of the active sheet.
I 'm trying to hide the inactive sheet fields.
Do you have a different solutions?
Tks for your prompt reply.

Re: tag fields using mapping table

Miguel_Angel_Baeyens — Fri, 16 Nov 2018 16:46:11 GMT

The "Current Selections" object was created to show whatever fields are selected at any time to any user. So if it is not a matter of data reduction (which could be done using section access) but instead just how to display the values selected in some fields, use a text object, where you can customize the list of fields you want to display and how they look like using functions like GetCurrentSelections(), GetFieldSelections(), etc. and applying string functions and conditions over them.

Re: tag fields using mapping table

fineasfalco — Fri, 16 Nov 2018 17:07:16 GMT

Yes I'm using a data reduction with section access to implement a data access control.
But I have sheets that show different analysis and I want to keep the filters applied for each of them. but so I see all selected fields.
Then ,The current selections box isn't the right object.
Tks.

Re: tag fields using mapping table

fineasfalco — Fri, 16 Nov 2018 17:28:52 GMT

Marcus wrote:"Unfortunately there's no way to adjust the hidden tag apart from through the reload script."
I'm noting the IFieldFlags class to consent to shows the tags.

I.e.
set fld=ActiveDocument.GetField("Plant")
fTags = fld.GetFieldFlags.Tags
dim Tags =""

for i=lbound(fTags) to ubound(fTags)
Tags=Tags & " " & fTags(i)
next
msgbox(Tags)

I'm asking, there is a way (macro, etc ) to forcing the flag status to modify the $hidden tag?