topic Re: where clause in qlikview load in QlikView

where clause in qlikview load

vikasgupta — Wed, 12 Dec 2012 08:50:05 GMT

Hello Everyone

Can I use Where Clause in Qlikview load bcz its not working in following Script OR I have to use MATCH Qlikview function of plz suggest !! While using this script table not found error is coming .

/***********************Order Table********************/

OrdLab:

LOAD OlTc,

OlYy,

OlChr,

OlNo,

OlSr,

OlQty,

OlSalRt;

SQL SELECT *

OlTc,

OlYy,

OlChr,

OlNo,

OlSr,

OlSrNo,

SUM(OlSalVal)AS LAB,

SUM(OlCstVal)AS CSTLAB

FROM EmrTst.dbo.OrdLab

WHERE OlTc='QT'

GROUP BY OlTc,OlYy,OlChr,OlNo,OlSr ;

Store OrdLab into ..\QVD\OrdLab.Qvd;

Drop Table OrdLab;

Thanks

Vikas Gupta

Re: where clause in qlikview load

Or — Wed, 12 Dec 2012 08:55:52 GMT

There's nothing wrong with the QV code. It looks like you forgot to put OISrNo into your GROUP BY clause, and your query is probably failing as a result.

Re: where clause in qlikview load

vikasgupta — Wed, 12 Dec 2012 09:07:29 GMT

Hi Orsh

No i am not using OISrNo in group by bcz I wants sum it by on only five key .

Thanks

Re: where clause in qlikview load

Wed, 12 Dec 2012 09:07:51 GMT

Hi,

Yes, u Missed to put a OISrNO into your Group by clause, hence ur query was getting failed.

~Kabilan K.

Re: where clause in qlikview load

Wed, 12 Dec 2012 10:03:04 GMT

So, remove OISrNO column from Select query..

Re: where clause in qlikview load

vikasgupta — Wed, 12 Dec 2012 10:31:53 GMT

Hi Kabilan

I checked it by adding OISrNO the Issue is that

SUM(OlSalVal)AS LAB,

FROM EmrTst.dbo.OrdLab

WHERE OlTc='QT'

GROUP BY OlTc,OlYy,OlChr,OlNo,OlSr ;

We can not Sum in load stattement using group by.

Thanks

Re: where clause in qlikview load

Wed, 12 Dec 2012 10:45:41 GMT

Did u use like below

OrdLab:

LOAD

OlTc,

OlYy,

OlChr,

OlNo,

OlSr,

OlSrNo,

LAB,

CSTLAB ;

SQL SELECT *

OlTc,

OlYy,

OlChr,

OlNo,

OlSr,

OlSrNo,

OlSalVal,

OlCstVal,

SUM(OlSalVal)AS LAB,

SUM(OlCstVal)AS CSTLAB

FROM EmrTst.dbo.OrdLab

WHERE OlTc='QT'

GROUP BY OlTc,OlYy,OlChr,OlNo,OlSr,OlSrNo ;

~Kabilan K.

Re: where clause in qlikview load

jagan — Wed, 12 Dec 2012 11:13:34 GMT

Hi Vikas,

I think * in your select query causing the problem. Try removing the asterisk and execute the script.

Regards,

Jagan.

Re: where clause in qlikview load

Mon, 18 Aug 2014 08:15:05 GMT

Hi Vikas:

Maybe it is because some qlikview function, such as 'AS' for rename, are not available for SQL.

Try using RESIDENT load.

Thanks