topic Re: LoadVariableCSV (change the delimiter) in Archived Groups

LoadVariableCSV (change the delimiter)

ali_hijazi — Tue, 22 Jul 2025 17:59:49 GMT

Hello
I have the variables of an application defined in an excel file from which I saved a copy as CSV with semi-column as separator
Now I want to import the variables using the LoadVariableCSV function

However, I'm getting an error as the ";" is not recognized and it seems that the function uses comma as a separator?
kindly advise
@Michael_Tarallo
@Anonymous
@Magnus_Berg

Re: LoadVariableCSV (change the delimiter)

Magnus_Berg — Tue, 22 Dec 2020 08:59:37 GMT

Hi Ali, sorry for late reply. Yes that function uses comma as separator. The reason is that the function parse the file into the script and as the qlik script uses ";" as line breaks its a security measure not to break the script. There is examples how a file should look in the framework demo container. example:
VariableName,VariableValue,Comments,Priority
vKPI.SumYear1997,"Sum(If(Year(OrderDate)=1997, Quantity*UnitPrice))","Sum last year",Sales

Re: LoadVariableCSV (change the delimiter)

ali_hijazi — Thu, 07 Jan 2021 16:18:31 GMT

Hello @Magnus_Berg
I did like you asked me to do above however I'm getting the double quotations in the definitions of the variables

kindly advise