Current selection

[soha1902]

I have one list box with always one selected value.

I want this selected field will not appear in Current Selection Box. How to do this?

Please help

[avinashelite]

Hi soha,

in order to make this you need to set hidden prefix in the script.

Try like this in the script.

Set hidePrefix='~';

then while loading the column

load

A as ~A

select * from......

this will hide the selection of this field

[tresesco · Accepted solution]

Read:

Exclude field from current selections box

Hide a Column from current selection Box

[jagan]

Hi,

Try like this

Rename the field to %fieldName format in script like below

Set hidePrefix='%';

TableName:

LOAD

*

Country AS %Country

FROM Datasource;

Now load the Dashboard, now the field name starts with % is not shown in the CurrentSelections box.

Hope this helps you.

Regards,

Jagan.

[vardhancse]

in order to do that, passing hide variables is only the alternate

[#6]

Hi,

If u have tried all the above replies and none of them have worked then, remove or delete that current selection box and create a new one. I m not sure but u can give a try.

[soha1902]

Hello everyone,

Thanks for reply. As per your suggestion I used  Set HidePrfix. It excluded list box selection from Current Selection but its also excluded from other charts also. I am using this list box to generate dynamic chart. if I used Set HidePrefix then my chart showing "No data to display".

Please suggest.

[jagan]

Hi,

Try adding the Dimension again in chart and list box by selecting Show System Fields option.

Regards,

Jagan.

[soha1902]

Now its working Jagan...I followed the link which tresesco shared and got the solution.....thank you very much for your help. In that link also they mentioned the same solution which you are mentioning here.