Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Hallaien
Contributor II

Tag Hidden fields and untag Master Items

Hi all, 

In order to have a few unhidden fields. I first tag all fields with '$hidden'. 

Then I add a list of fields and / or master items that are dimensions to be untagged. 

After the latest QLIK update it is not possible to untag the master item anymore if it has any kind of manipulation in it. 

For instance masterItemDate = Date(Date, 'YYYY-MM-DD' ) Would not work anymore. 

Only using the field Date would work, but we do some transformations in the master items and we don't want to show the raw field values. 

Another examples is: 

masterItemUSCountry = If(Country = 'US', 'Yes', 'No'). Here I don't want to show all country values but only Yes or No if it is US.

 

vFieldListNotHidden = ("'$(Date)', '$(masterItemDate)','$(masterItemUSCountry)'");

 

//This is the code to untag; 

for each i in $(vFieldListNotHidden)
 
untag field [$(i)] With '$hidden';
 
next f
 
 

 

Labels (2)
2 Replies
marksouzacosta

Hi @Hallaien,

What if you create those fields in your Load Script instead? That way you don't need to use Calculated Dimensions and your Untag field should work.

 

Regards,

Mark Costa

Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com

Hallaien
Contributor II
Author

Hi @marksouzacosta

 

That would be the Workaround. The point is that It used to work on calculated dimensions and now it doesn't. Something changed during the upgrade with the Untag function it seems..