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

Double Quots to Single Quote

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?

 

SonPhanHumanIT_1-1699962521717.png

 

 

Best regards Phan

Labels (1)
1 Solution

Accepted Solutions
Clever_Anjos
Employee
Employee

This code is working here 

Clever_Anjos_0-1699969454650.png

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));

View solution in original post

1 Reply
Clever_Anjos
Employee
Employee

This code is working here 

Clever_Anjos_0-1699969454650.png

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));