Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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? Although I am completely against this type of data source it looks like I will have to deal with it. Their current developer says that the filters don't work correctly and may not be able to work in QLIK. I find this hard to believe and once I get access I'm hoping this is not the case. I was just curious if there are limitations with QLIK and an Excel data source when compared to programs like Power BI.
@krilkbe
Regarding your question, yes it is possible to use Excel in Qlik. You can use cloud storage such as Dropbox, Google Drive..., Dropbox is the example I'm sending below:
Qlik Help:
Qlik video:
https://help.qlik.com/en-US/video/p2mcN6HbWW4
Regarts, Matheus