Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
somi
Contributor
Contributor

Problem with a WHERE statement

Hello all,

I would like to filter all numbers smaller than 215855772 in the vorgang_status column directly in the script. However, the import to the view always breaks with the error message unknown command (where "vorgang_status" <= 215855772)...

Here is my script:

LOAD "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag;
SQL SELECT "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag
FROM pdserp."public"."pds_rechnung";
where "vorgang_status" <= 215855772;

 

Would appreciate a response.

Many greetings
Martin

1 Solution

Accepted Solutions
Kushal_Chawda

@somi  remove the semicolon(;) as highlighted in red

LOAD "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag;
SQL SELECT "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag
FROM pdserp."public"."pds_rechnung";
where "vorgang_status" <= 215855772;

View solution in original post

1 Reply
Kushal_Chawda

@somi  remove the semicolon(;) as highlighted in red

LOAD "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag;
SQL SELECT "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag
FROM pdserp."public"."pds_rechnung";
where "vorgang_status" <= 215855772;