topic Re: Hide some fields in current selection box in QlikView

Hide some fields in current selection box

sergio0592 — Sun, 18 Sep 2016 17:37:53 GMT

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.qvw&host=demo11&anonymous=true

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

Re: Hide some fields in current selection box

sunny_talwar — Sun, 18 Sep 2016 20:15:35 GMT

Check this out:

HidePrefix – hiding fields

Re: Hide some fields in current selection box

sergio0592 — Mon, 19 Sep 2016 11:06:08 GMT

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

Re: Hide some fields in current selection box

sunny_talwar — Mon, 19 Sep 2016 20:19:01 GMT

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;