Qlikview to Database

rajni_batra — Fri, 02 Nov 2012 11:11:41 GMT

heloo an u help me this:

created connection loaded table from SQL but need to revert back the status to DB after some changes,

How can i do this???

ODBC CONNECT TO SQL (XUserId is GAXEKXFMWLYAHYVOTLZEXEB, XPassword is LGGXNXFMWLYAHYVOTLZEXBC);

SQL

EXEC ReconDB.dbo.tblBookingComponentDetail ??????????

//A:

//SQL SELECT

// "Booking ID",

// "Component Type",

// "Cost Price ",

// ID,

// "Selling Price ",

// status

//FROM ReconDB.dbo.tblBookingComponentDetail;

//STORE * from A into recon.qvd;

Directory;

LOAD [Booking ID],

[Component Type],

[Cost Price ],

if([Cost Price ]>30000 and [Cost Price ]<40000,'A',

if([Cost Price ]>40000 and [Cost Price ] < 50000,'B','C')) as status,

ID,

[Selling Price ]

FROM

recon.qvd

(qvd);

topic Qlikview to Database in QlikView