Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am converting a Qlikview application to Qlik Sense, and one of the steps include loading data from defined catalogs on the database server.
In Qlikview I loaded all the catalogs from a separate file managed by the customer, and then I do an iteration adding the data for each of the individual catalogs listed by using a variable in the connection string: Initial Catalog=$(vCustomerNo);
However in Qlik Sense since you are forced to use Libs you cannot use the variable solution like this as it verifies all connections and refuses to save the connection string if it is considered false.
Anyone have a good workaround for this?
you can always use the full path connection by uncheckng the StandardReload mode (which forces u to use the lib statements):
In desktop:
open the Settings.ini file (under qlik/sense..)
and add StandardReload=0 instead of StandardReload=1
=> now u can use full path in ur desktop (u need to close qlik sense desktop in order to change the settings file)
in server:
And there u go !
you can always use the full path connection by uncheckng the StandardReload mode (which forces u to use the lib statements):
In desktop:
open the Settings.ini file (under qlik/sense..)
and add StandardReload=0 instead of StandardReload=1
=> now u can use full path in ur desktop (u need to close qlik sense desktop in order to change the settings file)
in server:
And there u go !
Thanks Omar, however can I still use libs as well? There are many objects on the server that uses the Lib-function that still needs to function as before.
Sure