topic Re: Re: Some expressions are silently skipped in LoadVariableCSV in Archived Groups

Some expressions are silently skipped in LoadVariableCSV

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

I've stumbled upon that several times with various expressions, and have to import such expressions manually.

Minimal reproducible (on QDF 1.4.1) case is:

VariableName,VariableValue,Comments,Priority
SET vL.Dim,$(=Only(Field1)),,Additional formulas
SET vL.Sum,sum($(=Only(Field1))),,Additional formulas

Given that file slightly more complex vL.Sum expression imports as expected and slightly more simple vL.Dim is silently skipped.

Could we classify it as a bug?

Re: Some expressions are silently skipped in LoadVariableCSV

Magnus_Berg — Tue, 11 Nov 2014 07:26:22 GMT

Hi and thank's Vadim, we will have a look at this and get back to you.

Best regards

Magnus

Re: Re: Some expressions are silently skipped in LoadVariableCSV

vadimtsushko — Tue, 11 Nov 2014 07:59:59 GMT

By the way, in my Expresion Editor in addition to export in QDF format I have option to export expressions into plain qvs files with SET and LET commands.

So I have to deal with similiar problem there and I've found that for SET expressions that bit of code (in Python) works relatively reliably:

                if '$(' in exp:
                    command = 'let'
                    exp = exp.replace("'","~~~")
                    exp = exp.replace("$(","@(")
                    exp = "replace(replace('%s','~~~', chr(39)), '@(', chr(36) & '(')" % exp

For expressions in question I get next commands that work well when `included`

let vL.Dim = replace(replace('@(=Only(Field1))','~~~', chr(39)), '@(', chr(36) & '(');
let vL.Sum = replace(replace('sum(@(=Only(Field1)))','~~~', chr(39)), '@(', chr(36) & '(');

Re: Some expressions are silently skipped in LoadVariableCSV

Magnus_Berg — Tue, 11 Nov 2014 19:35:35 GMT

Hi Vadim, the bug have been identified and fixed (still version 1.4.1).

Best regards

Magnus
QlikView Deployment Framework Deploy Tool