topic Re: syntax function" Where" in edit escript????? in QlikView

syntax function" Where" in edit escript?????

fgolmahi — Wed, 25 Nov 2020 16:16:04 GMT

Hi Dear Friends

Please help me,I wrote function " Where " in edit script it is ok?

LOAD a,

FROM

[file.xlsx]

(ooxml, embedded labels, table is Sheet1);

Where a=3;

This is error

See attached please

Re: syntax function" Where" in edit escript?????

Anil_Babu_Samineni — Tue, 13 Jun 2017 06:49:50 GMT

Remove one semicolon

LOAD a,

FROM

[file.xlsx]

(ooxml, embedded labels, table is Sheet1) Where a=3;

Re: syntax function" Where" in edit escript?????

prma7799 — Tue, 13 Jun 2017 06:51:24 GMT

Remove colon after "(ooxml, embedded labels, table is Sheet1);"

colon means end of the statement

Use colon (;) after your last code of the script ...

Re: syntax function" Where" in edit escript?????

fgolmahi — Tue, 13 Jun 2017 06:54:01 GMT

Thanks

Re: syntax function" Where" in edit escript?????

fgolmahi — Tue, 13 Jun 2017 06:54:26 GMT

Thanks

Re: syntax function" Where" in edit escript?????

prma7799 — Wed, 14 Jun 2017 05:58:44 GMT

Glad to help you....

Re: syntax function" Where" in edit escript?????

fgolmahi — Wed, 14 Jun 2017 06:06:25 GMT

Hi Dear Friend

Please help me,

How to use Function " Where " in edit script If Read data from database ( SQL) ?????

Re: syntax function" Where" in edit escript?????

prma7799 — Wed, 14 Jun 2017 06:12:40 GMT

Like this in Qlikview

LOAD Code as NEW_Code,

Name as NEW_Name;

SELECT Code,

Name

FROM [Table Name]

WHERE [Code] LIKE 'PIN' AND [Dimension Value Type] = 0;

And in SQL

SELECT Code,

Name

FROM [Table Name]

WHERE [Code] LIKE 'PIN' AND [Dimension Value Type] = 0;

Re: syntax function" Where" in edit escript?????

Anil_Babu_Samineni — Wed, 14 Jun 2017 06:15:09 GMT

You can use either one approach from below

Approach 1

Connection String .....

SQL SELECT a, b

FROM <Table-Name> Where a=3;

Approach 2

Connection String .....

LOAD * Where a=3;

SQL SELECT a, b

FROM <Table-Name>;

Re: syntax function" Where" in edit escript?????

fgolmahi — Sat, 17 Jun 2017 06:09:49 GMT

thanks my friend

Approach 2 is correct