Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

Qlik Sense - hide columns from smart search SQL

Hi

I have been using SQL in my load script

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

https://help.qlik.com/en-US/sense/3.0/Subsystems/Hub/Content/Scripting/ScriptRegularStatements/Searc...

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?

1 Solution

Accepted Solutions
laddu_927
Specialist
Specialist

Can you try

Search Exclude [*CustomerID];

at the end of your script??

View solution in original post

3 Replies
laddu_927
Specialist
Specialist

Can you try

Search Exclude [*CustomerID];

at the end of your script??

View solution in original post

joeybird
Creator III
Creator III
Author

Hi

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

as

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
Creator III
Creator III
Author

Hi

found a way

Search Exclude [*DepartmentRepresentativer];

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

thank you x