Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
fineasfalco
Contributor III
Contributor III

tag fields using mapping table

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

 

5 Replies
marcus_malinow
Partner - Specialist III
Partner - Specialist III

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

fineasfalco
Contributor III
Contributor III
Author

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.


Miguel_Angel_Baeyens

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.

fineasfalco
Contributor III
Contributor III
Author

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.
fineasfalco
Contributor III
Contributor III
Author

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?