Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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
Hi
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.
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.
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.
Hi
I have tried with out hideprefix even though it works i think by default hide prefix value is '_'. Try once with out hideprefix
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
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