Qlikview to Qliksense

[WernerDC]

Hi,

We recently got the dual licenses and are busy migrating over to Qlik Sense.

I bumped in to this while doing a conversion.

SQL Select errors

For some reason Qlik Sense does not like it?

Please can you advise

[Vegar]

Did you create an connection to the database? Did you connect to the database before running the script?

Note that the connect to database syntax is a bit different between QV and QS.

[WernerDC]

Hi,

Thanks for the Quick reply.

See here an example of how it looks.

I connect to the database first thing.

Cheers

[Vegar]

My best tip is to try to use the data load wizard to get the syntax correct.  Try to create an new data extract using the wizard and compare it to how your script is written. 

[WernerDC]

Thank you for your time...

I will play around with this.

Kind regards