Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone, I'm new to Qlik and I have a problem that seems like it should be an easy fix. I'm using the free Desktop version and have a connection to a Microsoft SQL Server that stores a database of information on one of our clients. I'd like to use the map functionality, but our client uses "Markets" that correspond to states (for the most part) but are labeled randomly.
To get around this issue, I created a very small table in Excel that corresponds the appropriate Market to the appropriate location, then my plan was to associate the two separate tables together by Market in Qlik.
I can load the database when it is by itself via a long SQL query, but when I add excel file, I get an error:
bunch of SQL then,
I believe it's because Qlik is adding the "Set dataManagerTables...." line after the SQL query, but I'm not sure exactly how to fix this.
Please let me know how to do this correctly or if there is a better way to organize the location data, thanks!