Solved: How to use Function " Where " ????? - Qlik Community

fgolmahi · ‎2017-06-14

Hi Dear friends

Please Help me

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

see attachment please

Anil_Babu_Samineni · ‎2017-06-14

You can do with it

Sample:

Load * from Qvd Where Month = 'April';

Store Sample into Path\Sample_April.qvd (qvd);

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2017-06-14

You can use before semi colon only

Load * from Qvd Where Condition;

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

micheledenardi · ‎2017-06-14

Put the Where condition after (qvd) and before ;

Load

a,

b,

c

from MyQvd.qvd (qvd) where CONDITIONS ;

Where Clause ‒ QlikView

Video Link : 4112

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

devarasu07 · ‎2017-06-14

Hi,

try like below

Fact:

LOAD

Table_Columns;

SQL SELECT *

FROM [SQL table name]

Where Condition = value;

STORE Fact into $(vQVDPath)\Fact.QVD;

prma7799 · ‎2017-06-14

Remove colon..

prma7799 · ‎2017-06-14

colon means end of the statement

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

fgolmahi · ‎2017-06-14

fgolmahi · ‎2017-06-14

thanks Dear

Is that not work

devarasu07 · ‎2017-06-14

Hi,

Refer below screen,

fgolmahi · ‎2017-06-14

Thanks Dear

Don't work it

please help me