Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us March 10th, 7 Ways Modern Analytics Can Help You Take Smarter Action. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
colville
Contributor
Contributor

Load Functions

A normal statement in SQL in which you need to select specific options will be:

SELECT *

FROM Organization

WHERE "Org_Name = 'CONSULTING'

or "Org_Name" = 'ANALYTICS'

or "Org_Name" = 'APPLICATION SERVICES'

or "Org_Name" = 'BUSINESS PROCESS SERVICES'

or "Org_Name" = 'Security'

or "Org_Name" = 'ENTERPRISE & CLOUD APPS'

or "Org_Name" = 'WORKPLACE & MOBILITY'

or "Org_Name" = 'CLOUD, WORKLOAD PLATFORMS & ITO';

But when we try translate this in QlikSense  Data Load Editor

LOAD

"Org_ID"

"Location"

"Table 1",

"Table 2",

"Table 3",

"Table 4",

"Org_Name"


FROM [lib://Utilization/Organization.xlsx]

(ooxml, embedded labels, table is Organization)

WHERE "Org_Name = 'CONSULTING'

or "Org_Name" = 'ANALYTICS'

or "Org_Name" = 'APPLICATION SERVICES'

or "Org_Name" = 'BUSINESS PROCESS SERVICES'

or "Org_Name" = 'Security'

or "Org_Name" = 'ENTERPRISE & CLOUD APPS'

or "Org_Name" = 'WORKPLACE & MOBILITY'

or "Org_Name" = 'CLOUD, WORKLOAD PLATFORMS & ITO';

It's not pulling the data i want which brings me to my question.

Is there another way or syntax that QS could recognize and i could pull the desired data from the File?

Is the Where and Or statement not allowed in Data Load Editor to be use the way i'm using it?

What could be the best way of getting the data?

1 Solution

Accepted Solutions
poojashribanger
Creator II
Creator II

Hi,

Try this:



LOAD

"Org_ID"

"Location"

"Table 1",

"Table 2",

"Table 3",

"Table 4",

"Org_Name"


FROM [lib://Utilization/Organization.xlsx]

(ooxml, embedded labels, table is Organization)

WHERE wildmatch(Org_Name, 'CONSULTING', 'ANALYTICS', 'APPLICATION SERVICES', 'BUSINESS PROCESS SERVICES','Security', 'ENTERPRISE & CLOUD APPS', 'WORKPLACE & MOBILITY', 'CLOUD, WORKLOAD PLATFORMS & ITO');

View solution in original post

4 Replies
m_woolf
Master II
Master II

I notice that you are missing a double quote in the first line. Other than that, your syntax should work.

Is there a chance that some of the data in the Excel workbook might contain leading or trailing spaces?

colville
Contributor
Contributor

In the actual data the double quotes was there that's just a sample query i created to represent the query i'm currently using. cause the query run fine in MSSQL. but the data don't get  pulled in QS the tables are blank

poojashribanger
Creator II
Creator II

Hi,

Try this:



LOAD

"Org_ID"

"Location"

"Table 1",

"Table 2",

"Table 3",

"Table 4",

"Org_Name"


FROM [lib://Utilization/Organization.xlsx]

(ooxml, embedded labels, table is Organization)

WHERE wildmatch(Org_Name, 'CONSULTING', 'ANALYTICS', 'APPLICATION SERVICES', 'BUSINESS PROCESS SERVICES','Security', 'ENTERPRISE & CLOUD APPS', 'WORKPLACE & MOBILITY', 'CLOUD, WORKLOAD PLATFORMS & ITO');

View solution in original post

Ivan_Bozov
Luminary
Luminary

You are also missing commas

LOAD

"Org_ID",

"Location",

"Table 1",

"Table 2",

"Table 3",

"Table 4",

"Org_Name"

FROM [lib://Utilization/Organization.xlsx]

(ooxml, embedded labels, table is Organization)

WHERE MATCH("Org_Name", 'CONSULTING', 'ANALYTICS', 'APPLICATION SERVICES', 'BUSINESS PROCESS SERVICES', 'Security', 'ENTERPRISE & CLOUD APPS', 'WORKPLACE & MOBILITY', 'CLOUD, WORKLOAD PLATFORMS & ITO');