How to use Function " Where " ?????

[fgolmahi]

Hi Dear friends

Please Help me

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

see attachment please

[prabhas277]

Hi,

Remove the Semicolon  to the store statement (After Qvd) then write the where condition

[Anil_Babu_Samineni · Accepted solution]

You can do with it

Sample:

Load * from Qvd Where Month = 'April';

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

[fgolmahi]

please help me

[passionate]

Hi Fatemeh,

You can use Debug option in Qlikview load script.

The issue you raised is syntactical error. Please paste your code so that we can help.

Regards,

Pankaj

[Anil_Babu_Samineni]

SQL Doesn't make Blue color because Qlik is not the SQL engine. It will work. And that you need to load then check whether qvd stores the condition respect data

[fgolmahi]

thanks but not correct

[prma7799]

SQL Select  AdmCode,

IcdCode,

GICDDate,

GICDName,

GICDNote,

GICDPersCode,

GICDStatus,

GICDStatusName,

GICDType

From Shafa.dbo"GiveICD_QlickView"

where "Put your condition here";

STORE cod into cod.qvd(qvd);

[fgolmahi]

error in debug

[fgolmahi]

don't correct

[prma7799]

Please share that script ...