topic Re: Transfer QlikView application to QlikSense in QlikView

Transfer QlikView application to QlikSense

Anonymous — Mon, 28 Dec 2015 08:01:49 GMT

I try to copy and paste the script from qlikview to qliksense but when I reload the data. it becomes error..

Re: Transfer QlikView application to QlikSense

Chanty4u — Mon, 28 Dec 2015 08:04:55 GMT

u need to chnge the Qvd path ..

bcz its diffr frm Qlikview to Qliksense

Re: Transfer QlikView application to QlikSense

Peter_Cammaert — Mon, 28 Dec 2015 09:13:03 GMT

What error message do you get when you run a QlikView script in Qlik Sense?

Re: Transfer QlikView application to QlikSense

Anonymous — Mon, 28 Dec 2015 12:38:51 GMT

[tblDoctorAppointment]:

LIB CONNECT TO [192.168.0.3-MSSQL2012,4200];

LOAD [AppointmentID],

[UserID],

[notes];

SQL SELECT "AppointmentID",

"UserID",

"notes"

FROM "Clinic"."dbo"."tblDoctorAppointment";

[tblDoctorVisit]:

LIB CONNECT TO [192.168.0.3-MSSQL2012,4200];

LOAD [DoctorID] as [UserID],

[visitAmount]; <<<<<< I try to change the name for doctorID into UserID to make relation

SQL SELECT "DoctorID" as "UserID", between them like qlikview but it doesn't working !!<<<<<<,<

"visitAmount"

FROM "Clinic"."dbo"."tblDoctorVisit";

Re: Transfer QlikView application to QlikSense

Anonymous — Mon, 28 Dec 2015 12:40:02 GMT

Once I change the name to make relations between two tables the qliksense give me error that i can't change the name

Re: Transfer QlikView application to QlikSense

Peter_Cammaert — Mon, 28 Dec 2015 12:43:43 GMT

Why are you chaning DoctorID twice? Once in the SQL SELECT and once in the PRECEDING LOAD that follows. Remove the as "UserID" from your SELECT statement and the script will work.

BTW another tip: Move the table label [tblDoctorVisit]: after the CONNECT statement. It's part of the LOAD/SELECT combo but has nothing to do with a CONNECT statement.