Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewforum
Creator II

Scripting/ETL differences in QlikView and Qlik Sense

Can someone please list out the Scripting/ETL differences between QlikView and Qlik Sense. I heard that 80% is same 20% varies. I would like to know those 20% which varies when compared to Qlik View.

Please help!

2 Replies
Tim_Wensink
Partner - Contributor III

Hi,

The big difference is that in Qlik Sense you always load data from a library. If you want to load data from a file in a specific folder, you should first create a library linking to that folder and then load the data (I have a library named test containing a file named test):

LOAD
*
FROM [lib://Test/test.xlsx]
(ooxml, embedded labels, table is Sheet1);

In Qlikview, you could just load the data by referencing the filename (assuming the file is in the same folder as the .qvw file):

Test:
LOAD *
FROM
[test.xlsx]
(ooxml, embedded labels, table is Sheet1);

As far as I know there are no other major differences between Qlikview script and Qlik Sense script

Greetings,

Tim Wensink

 

qlikviewforum
Creator II
Author

Thanks a lot explaining me this.

Others: Please let me know if you have noticed any other differences. It will be easy for me to learn it as we don't have the license in my organization.