topic QDF : call LoadVariableCSV how to load expression with ' ,' sign in expression using in Archived Groups

QDF : call LoadVariableCSV how to load expression with ' ,' sign in expression using

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

Hello,

I'am starting to use QDF. The call LoadVariableCSV enables to load expressions from .csv file.

All nice but when I have an expression with , in them, it does nt seem to work. Anbody how to solve this?

Kind regards,

Arjen

example : row 3 does not work

VariableName,VariableValue,Comments,Priority

LET eG.Sales€YTD,sum($(vSetYTD)Sales),,Sales

LET eG.Margin%LYTDIFC1, sum({<$(vSetPreviousYearYTDModifier), %IFC={'1'}>}Margin)/sum({<$(vSetPreviousYearYTDModifier), %IFC={'1'}>}Sales), , Sales

,,,

Re: QDF : call LoadVariableCSV how to load expression with ' ,' sign in expression using

Anonymous — Fri, 21 Oct 2016 20:36:20 GMT

‌ wrap the expression in double quotation marks. I.e "expression". This ensures that when the expression includes a comma it is loaded correctly.

I Also wrap the entire expression in parenthesis. Therefore if you use it as a numerator or denominstor the correct arithmetic order is maintained.

I.e. "(Sum[sales])"

Re: QDF : call LoadVariableCSV how to load expression with ' ,' sign in expression using

Magnus_Berg — Mon, 31 Oct 2016 07:28:48 GMT

Hi Arjen, ad Damian sais use double quotation marks and also use SET instead of LET (or leave operator out completely and SET will be default) as LET will try to evaluate the expression and this might not be possible. So like this:

eG.Margin%LYTDIFC1, "sum({<$(vSetPreviousYearYTDModifier), %IFC={'1'}>}Margin)/sum({<$(vSetPreviousYearYTDModifier), %IFC={'1'}>}Sales)", , Sales

Hope that this helps

Regards

Magnus