topic Re: Exclude a field from Current Selections Box in QlikView

Exclude a field from Current Selections Box

bvanderzanden — Fri, 02 Mar 2012 14:55:12 GMT

Is there anyway to exclude a field from showing up in the Current Selections box?

I have a couple of fields that are used for some functionality that I don't want the users to be able to see.

I've been able to configure it so that they can't remove the selection, but I'd prefer to not even show this to the user.

Exclude a field from Current Selections Box

dirk_konings — Fri, 02 Mar 2012 15:03:38 GMT

Give these fields a prefix like '%'
Put this in your script : set HidePrefix = '%' ;

This field will become a system field, thes won't show up in the current selections box.

Exclude a field from Current Selections Box

bvanderzanden — Fri, 02 Mar 2012 15:43:20 GMT

Dirk-

Thx, that worked.

Re: Exclude a field from Current Selections Box

Tue, 05 Feb 2013 09:44:15 GMT

Hi Dirk,

I have the same problem.

I don't want a certain field to be shown in current selection.

The problem is that in my loading script I do load *.

So how can I add % to its name?

Thanks,

Inna

Re: Exclude a field from Current Selections Box

dirk_konings — Tue, 05 Feb 2013 09:47:47 GMT

Hi Inna,

Use the Rename Field

Rename field aaaKey to %aaaKey;

Put this after the load statement.

Dirk

Re: Exclude a field from Current Selections Box

Tue, 05 Feb 2013 12:35:39 GMT

Hi, Dirk.

It does not work for me .

This is my script :

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

TempNetworkDomainData:

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_M1*.qvd

(qvd);

Rename field PPublisherName to %PPublisherName;

//Set hideprefix='%';

Concatenate

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_RA*.qvd

(qvd);

Rename field PPublisherName to %PPublisherName;

//Set hideprefix='%';

concatenate

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_ORIDIAN*.qvd

(qvd);

Rename field PPublisherName to %PPublisherName;

//Set hideprefix='%';

And also I unchecked Show system fields in properties of the chart.

What else can be done?

Thanks,

Re: Exclude a field from Current Selections Box

dirk_konings — Tue, 05 Feb 2013 12:44:54 GMT

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='$#,##0.00;($#,##0.00)';

SET TimeFormat='hh:mm:ss TT';

SET DateFormat='DD/MM/YYYY';

SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT';

SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Set hideprefix='%';

TempNetworkDomainData:

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_M1*.qvd

(qvd);

Concatenate

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_RA*.qvd

(qvd);

concatenate

LOAD *

FROM D:\QlikView\YbrantDigital\Qvd\sql_data\DAILY_ORIDIAN*.qvd

(qvd);

Rename field PPublisherName to %PPublisherName;

Re: Exclude a field from Current Selections Box

Tue, 05 Feb 2013 12:57:32 GMT

Hi Dirk,

worked like a miracle.

Thanks!