topic Re: Qlik Sense - hide columns from smart search SQL in App Development

Qlik Sense - hide columns from smart search SQL

joeybird — Thu, 30 Mar 2017 07:55:23 GMT

I have been using SQL in my load script

I wish to exclude some columns so they don't appear in the smart search

I don't seem to have much luck with this.. I have tried

CustomerID AS [*CustomerID],

with no joy. Where am I going wrong please?

Anonymous — Thu, 30 Mar 2017 07:58:31 GMT

Can you try

Search Exclude [*CustomerID];

at the end of your script??

joeybird — Thu, 30 Mar 2017 08:28:06 GMT

this hides the column from the smart search, Great thank you ...but

but does not hide any column with data within

I went on to exclude Manager

Search Exclude [*Manager*];

but when I completed a smart search for "Manager"

it found a column that contained the word Manager

DepartmentRepresentative (this is the column name it brought back)

Joe Bloggs,Wales,Manager

is there a way to stop smart search searching for the word Manager within the columns too?

please help

joeybird — Thu, 30 Mar 2017 08:38:12 GMT

found a way

Search Exclude [*DepartmentRepresentativer];

just have to make sure I exclude all the columns that contain the word "Manager"

thank you x