topic Re: Problem with SQL join statement in LOAD statement in QlikView

Problem with SQL join statement in LOAD statement

Fri, 03 Aug 2012 19:14:40 GMT

I am trying to load this into an already existing script:

SoshipheaderFashion:

LOAD ShipDateActFash, CustIDFash, SlsperIDFash, totMerchFash, TotmerchFash as FashCuryTotMerch;

SQL SELECT Soshipheader.ShipDateAct, Soshipheader. CustID, Soshipheader.SlsperID, Soshipheader.Totmerch from DIGITALAPP.DBO.SoShipheader

JOIN DIGITALAPP.DBO.SoShipline on Soshipheader.shipperid = soshipline .shipperid and soshipheader.cpnyid = soshipline.cpnyid

JOIN DIGITALAPP.DBO.inventory on Soshipline.invtid = inventory.invtid

where soshipheader.shipdateact > getdate() -1 and inventory.classid in ('SUNG','HAND','WALL','BKPK','CLOTH','CUFF','TRAV','TRAVEL','WATCH')

;

I get the following error on reload:

Field not found - <ShipDateActFash> and then it lists the SQL query

Any ideas?

Re: Problem with SQL join statement in LOAD statement

MayilVahanan — Fri, 03 Aug 2012 19:20:31 GMT

In sql, there is ShipDateActFlash field? Please check that and run it

Re: Problem with SQL join statement in LOAD statement

Fri, 03 Aug 2012 19:27:33 GMT

Actually...I seem my issue.

Basically heres whats going on:

This table already exists in this script. However- they want a 2ndary graph to show Sales for only certain categories.

Now that I think about it, I shouldnt be "reloading" that soshipheader table but in reality I should be loading Soshipline and Inventory on their own, and use my "where" statement in the actual graph....

Correct?

Re: Problem with SQL join statement in LOAD statement

MayilVahanan — Fri, 03 Aug 2012 19:37:45 GMT

You need load certain categories values alone means, use if condition..

You need certain categories for all related fields means, use where condition..

But you mentioned, already table exists then why you load once again use the same table, you can use condition in chart itself.

Re: Problem with SQL join statement in LOAD statement

Fri, 03 Aug 2012 19:44:23 GMT

Thanks for the help. I know what I have to do now. Thanks again