topic Selection Box in QlikView

Selection Box

Tue, 24 Apr 2012 03:42:42 GMT

Hello Everyone,

Does anyone know why the selection box does not show the selected item in sample 'Whats New in QlikView11.qvw' ?

It is on the Reports tab, when I select any items from the '_dimension', and/or '_metrics', I couldn't see the selected items in the Selection Box.

Please see the attached screenshot below.

I'm wondering how they did this, and whether or not there is way to show the selected items in the 'Selction Box' in that qvw file.

Thanks a lot for your help.

Re: Selection Box

Tue, 24 Apr 2012 04:43:55 GMT

Hi,

These are considered as fields which you want to hide.

set HidePrefix='_' ;

there is a variable hideprefix if it is set as _ , so if you name any field which name starts from _ then you will be able to hide this field from selection box.

Also, that field is treated as system field and that field itself is not visible when u dont select the check box show system fields.

You can try this in your applications also.

Ashutosh

Re: Selection Box

Tue, 24 Apr 2012 04:57:40 GMT

When u give the field name starting with _ then the selections made in that field wont visible in current selection box and that field itself is not visible when u dont select the check box show system fields.

Selection Box

Tue, 24 Apr 2012 05:18:36 GMT

Hi Ashutosh Paliwal,

Thank you very much for your kind help. Your answer is correct, I've tested it.

How did you know that? Well done, excellent.

Selection Box

Tue, 24 Apr 2012 05:21:52 GMT

Hi Sweth_24,

Thank you for your kind assistance.

It might be a must to add

SET HidePrefix='_'

in the script to enable the _ prefixed field invisible

I've tested it following what Ashutosh Paliwal said.

Cheers.

Selection Box

Tue, 24 Apr 2012 05:26:30 GMT

I have tried with out hideprefix even though it works i think by default hide prefix value is '_'. Try once with out hideprefix

Selection Box

Tue, 24 Apr 2012 05:48:51 GMT

Hi,

Yes I have seen it work sometimes but also have seen it not work most of times.

So, suggestion will be to use it always to be sure that it works.

Also, Qlikview manual does not say that it is set to _ by default.

And yes it is a one time variable initialization, you if you set it once and then you delete that variable (remove set statement) still those fields will be kept hidden.

Also, it is maintained through binary load also. In Binary load variables are not loaded but this hideprefix is loaded.

So, if you set this variable in a qlikview file and you take binay load of the qlikview app into another qlikview app. so fields from both of the Qlikview apps will be hidden.

Ashutosh

Re: Selection Box

ngulliver — Wed, 02 May 2012 13:38:00 GMT

Hi,

Steve Dark has a blog on this:

http://www.quickintelligence.co.uk/have-something-to-hide/

It may be of use to you.

regards,

Neil