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.
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
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.
