Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
vadimtsushko
Partner - Creator III
Partner - Creator III

Some expressions are silently skipped in LoadVariableCSV

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?

1 Solution

Accepted Solutions
Magnus_Berg
Employee
Employee

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

Best regards

Magnus
QlikView Deployment Framework Deploy Tool

View solution in original post

3 Replies
Magnus_Berg
Employee
Employee

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

Best regards

Magnus

vadimtsushko
Partner - Creator III
Partner - Creator III
Author

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) & '(');

Magnus_Berg
Employee
Employee

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

Best regards

Magnus
QlikView Deployment Framework Deploy Tool