Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator III

Variable

Hello All,

                    In my application created a variable like vData and value is 'A' and i took another variable i.e. vData1. But in this variable data should be displayed without ' '. It should display only A. Can any one tell me how to do.

Regards,

R.Bharat Kishore

1 Solution

Accepted Solutions
jvitantonio
Luminary Alumni
Luminary Alumni

=replace(vData,chr(39),'')

Put this in a text box object to see how it works

View solution in original post

9 Replies
jvitantonio
Luminary Alumni
Luminary Alumni

Use function Replace()

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Did you tried within $(=)

     like =$(=vData)

Celambarasan

bharatkishore
Creator III
Creator III
Author

Can you explain me clearly how to do. I am new to qlikview.

jvitantonio
Luminary Alumni
Luminary Alumni

=replace(vData,chr(39),'')

Put this in a text box object to see how it works

bharatkishore
Creator III
Creator III
Author

Thannks a lot

bharatkishore
Creator III
Creator III
Author

HI Celambarasan,

                                       I tried but i am getting value as 0.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

How did you stored the value in variable vData?By button or in edit script or variable overview?

Celambarasan

bharatkishore
Creator III
Creator III
Author

i just took a variable i.e. vData and i gave value as 'A'. Now in a text object when i take another variable i.e. vData1 it should display without quotes i.e. only A.

CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

     Then Assign vData1 value as =vData

Celambarasan