Hide some fields in current selection box

[sergio0592]

Hi all,

I often use customizables tables as described in a post from Jennell McIntire https://community.qlik.com/blogs/qlikviewdesignblog/2014/01/31/customizable-straight-table

But, in my qvw. when user makes selections on dimension or metrics/metrics no fields, the selection appears in the current selection box. I'd like to avoid that, is there a way fir choose wich field must appear in the current box?

I have probably missed a step because the post refers to http://us-d.demo.qlik.com/QvAJAXZfc/opendoc.htm?document=qvdocs%2FCall%20Detail%20Record%20Analysis....

(report tab) and dimensions and metrics don't appear in box.

[sunny_talwar · Accepted solution]

Check this out:

HidePrefix – hiding fields

[sergio0592]

Thanks, it works but i had to remove the QUALIFY before the dimension/metrics tables. And i don't like scripting without QUALIFY statement!!

[sunny_talwar]

You can always use QUALIFY and then at the very end of the script rename your fieldname

How to rename a field in qlikview

RENAME Field TableName.FieldName to ~FieldName;