Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Highlighted
surawutsae
New Contributor III

I want to where data

Header 1Header 2Header 3
PriceRef.1

Ref.2

500Oil-
900WAG2
700WAG-
800WAG3
799WAG-

where ref.1 not Oil and where ref.1 WAG not 2,3

EX.

Header 1Header 2Header 3
PriceRef.1Ref.2
700WAG-
900--
10 Replies
alexpanjhc
Valued Contributor

Re: I want to where data

Why 900 is there instead 799?

Employee
Employee

Re: I want to where data

The correct answer should b:

Header 1Header 2Header 3
PriceRef.1Ref.2
700WAG-
799WAG-

Could you explain where do you want? Loading statement or graph?

Ricardo Gerhard
OEM Solution Architect
LATAM
surawutsae
New Contributor III

Re: I want to where data

Sorry i write wrong


EX. 700 and 799

surawutsae
New Contributor III

Re: I want to where data

Yes, you are correct.

I want to load data

yogarajsubraman
New Contributor III

Re: I want to where data

hi, try this

TABLE:

LOAD Price,

     Ref.1,

     Ref.2

FROM

[data.xlsx]

(ooxml, embedded labels, header is 1 lines, table is Sheet1)where Ref.1='WAG' AND not Match(Ref.2,2,3);

Partner
Partner

Re: I want to where data

Hi,

Try this.

Capture.PNG

surawutsae
New Contributor III

Re: I want to where data

I load data from SQL but I want to load some data  and I have Problem following


FROM "MIS_DataLake_UAT".dbo."SAP_COST"

where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),

where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),

where "S_REF_KEY_1" <> ('OIL'),

where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);

Capture.JPG

Problem

Capture.JPG

surawutsae
New Contributor III

Re: I want to where data

I load data from SQL but I want to load some data  and I have Problem following


FROM "MIS_DataLake_UAT".dbo."SAP_COST"

where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),

where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),

where "S_REF_KEY_1" <> ('OIL'),

where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);

Problem

incorect syntax near ','.

surawutsae
New Contributor III

Re: I want to where data

I load data from SQL but I want to load some data  and I have Problem following


FROM "MIS_DataLake_UAT".dbo."SAP_COST"

where "S_ACCOUNT" = ('68001000','52001500','68119000','68002000'),

where "S_SESSION_NAME" <> ('ARF0214DMSAR','ARF0114DMSAR','APF0214DMSAP','APF0114DMSAP','APF0114ADVAP','APF0114AD2AP'),

where "S_REF_KEY_1" <> ('OIL'),

where "S_REF_KEY_1" = 'WAG' and "S_REF_KEY_2" <> (2,3);

Problem

incorect syntax near ','.