Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have the following issue:
I've created a simple example where I'm storing a variable on the surface, which I then want to use as a constraint in a table. However, I'm facing an issue where Qlik is adding double quotation marks at the beginning and end. I would like something dynamic, similar to what I have in line 9. Does anyone have any ideas?
Best regards Phan
This code is working here
set vTest="'a','b','c'";
LOAD
"FieldName",
FieldIsSynthetic,
FieldIsHidden,
FieldIsSemantic,
FieldDistinctOnly,
FieldCardinality,
FieldTotalCount,
FieldISLocked,
FieldAlwaysOneSelected,
FieldIsNumeric,
FieldComment,
FieldSize_GB,
FieldSize_MB,
FieldID,
_IncrementalGUID,
_KeyFields
FROM [lib://DataFiles/app_analyzer_Fields_3.0.1.qvd]
(qvd)
Where Match(FieldName,$(vTest));
This code is working here
set vTest="'a','b','c'";
LOAD
"FieldName",
FieldIsSynthetic,
FieldIsHidden,
FieldIsSemantic,
FieldDistinctOnly,
FieldCardinality,
FieldTotalCount,
FieldISLocked,
FieldAlwaysOneSelected,
FieldIsNumeric,
FieldComment,
FieldSize_GB,
FieldSize_MB,
FieldID,
_IncrementalGUID,
_KeyFields
FROM [lib://DataFiles/app_analyzer_Fields_3.0.1.qvd]
(qvd)
Where Match(FieldName,$(vTest));