Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
bvanderzanden
Partner - Contributor II
Partner - Contributor II

Exclude a field from Current Selections Box

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.

1 Solution

Accepted Solutions
dirk_konings
Creator III
Creator III

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.


View solution in original post

7 Replies
dirk_konings
Creator III
Creator III

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.


bvanderzanden
Partner - Contributor II
Partner - Contributor II
Author

Dirk-

Thx, that worked.

Not applicable

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

dirk_konings
Creator III
Creator III

Hi Inna,

Use the Rename Field

Rename field aaaKey to %aaaKey;

Put this after the load statement.

Dirk

Not applicable

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,

dirk_konings
Creator III
Creator III

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;

Not applicable

Hi Dirk,

worked like a miracle.

Thanks!