I am fairly new to QLIK I used it back in 2017 to 2019 then we switched to Power BI and Spot Fire once QLIK took away free access. The company I work for now is using QLIK and instead of using a SQL data source they are using Excel spreadsheets. I haven't received my license yet but I wanted to know if there are limitations with Excel spreadsheets as a data source or if there are any tips or tricks when using Excel data?
Hi, The limitation will be in automating updates, as you will sometimes need to manually update the file then re add, you can look at using microsoft drives(cloud) and using it as your data source, you can set up your data structure in excel that will make updating seemless. i hope this helps?..Cheers
