Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

How to input a string without putting in single quotes in input box

Hi All, We have created a variable to input the account number which is a of string type and its value will be like ' 123-1', and it will fetch the data from the blackened data base as per this input. Every time we need to enter this in single quotes. Please help to remove this single quotes either in load script or in input box. The input should accept as 123-1 though it is as string. Please help.
1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi Swetha

I think the following should work:

let vRequestBody_custDet= vRequestBody_custDet&'<accountNo>$(vaccountnumber)</accountNo>';

Otherwise try:

let vRequestBody_custDet= vRequestBody_custDet&'<accountNo>'&'$(vaccountnumber)'&'</accountNo>';

Regards,

Mauritz

View solution in original post

4 Replies
Highlighted
Partner
Partner

Hi Swetha

How are you using this variable? In set analysis? Because then you can just reference the variable as '$(vVariable)' rather than $(vVariable).

Alternatively you can have another variable (for example vVariable2) which you can put as the variable for your input box and then you can make the definition of vVariable equal to '$(vVariable2)' and keep on using vVariable the way you are doing now. 

Hope this helps.

Mauritz

Highlighted
Contributor III
Contributor III

Hi Mauritz,

Thanks for your time!

Please find below my code which is used to pass to get that particular account number.

let vRequestBody_custDet= vRequestBody_custDet&'<accountNo>'&$(vaccountnumber)&'</accountNo>';

Highlighted
Partner
Partner

Hi Swetha

I think the following should work:

let vRequestBody_custDet= vRequestBody_custDet&'<accountNo>$(vaccountnumber)</accountNo>';

Otherwise try:

let vRequestBody_custDet= vRequestBody_custDet&'<accountNo>'&'$(vaccountnumber)'&'</accountNo>';

Regards,

Mauritz

View solution in original post

Highlighted
Contributor III
Contributor III

This is working fine. Thanks alot.

let vRequestBody_custDet= vRequestBody_custDet&'<accountNo>'&'$(vaccountnumber)'&'</accountNo>';