Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Field name with space issue

Hi guys,

I am writing this script

NoConcatenate

          [$(vCustomFieldName)]:

          LOAD TxnID, CustomFieldValue as [$(vCustomFieldName)]

          From [$(Path)$(_CompFileName)_v_CustomFieldsForTxnNames.qvd]

          (qvd)

          Where CustomFieldName = '[$(vCustomFieldName)]';

It works when the value of vCustomFieldName does not have any space in between. when it has space then the

"WHERE" clause does not work.

Can you plz suggest me that what should be right statement of hwere caluse when we spaces in value of vCustomFieldName.

Regards,

Saurabh

1 Solution

Accepted Solutions
Henric_Cronström

You have one pair of quotes to much. Use the following instead:

Where CustomFieldName = '$(vCustomFieldName)';


HIC

View solution in original post

1 Reply
Henric_Cronström

You have one pair of quotes to much. Use the following instead:

Where CustomFieldName = '$(vCustomFieldName)';


HIC

View solution in original post