Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Problem with SQL join statement in LOAD statement

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?

1 Solution

Accepted Solutions

Re: Problem with SQL join statement in LOAD statement

Hi

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

     Or

     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.

4 Replies

Re: Problem with SQL join statement in LOAD statement

HI

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

Not applicable

Re: Problem with SQL join statement in LOAD statement

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

Hi

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

     Or

     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.

Not applicable

Re: Problem with SQL join statement in LOAD statement

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

Community Browser