topic Re: Current selection in QlikView

Current selection

soha1902 — Fri, 11 Jul 2014 05:12:21 GMT

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

Re: Current selection

avinashelite — Fri, 11 Jul 2014 05:15:18 GMT

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

Re: Current selection

tresB — Fri, 11 Jul 2014 05:21:15 GMT

Read:

Exclude field from current selections box

Hide a Column from current selection Box

Re: Current selection

jagan — Fri, 11 Jul 2014 06:00:13 GMT

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.

Re: Current selection

vardhancse — Fri, 11 Jul 2014 06:08:03 GMT

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

Re: Current selection

Fri, 11 Jul 2014 07:06:18 GMT

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.

Re: Current selection

soha1902 — Fri, 11 Jul 2014 07:51:14 GMT

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.

Re: Current selection

jagan — Fri, 11 Jul 2014 08:01:02 GMT

Hi,

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

Regards,

Jagan.

Re: Current selection

soha1902 — Fri, 11 Jul 2014 08:07:29 GMT

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.