topic Variable in QlikView

Variable

bharatkishore — Tue, 13 Mar 2012 13:28:22 GMT

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

Variable

jvitantonio — Tue, 13 Mar 2012 13:32:00 GMT

Use function Replace()

Variable

CELAMBARASAN — Tue, 13 Mar 2012 13:33:00 GMT

Hi,

Did you tried within $(=)

like =$(=vData)

Celambarasan

Variable

bharatkishore — Tue, 13 Mar 2012 13:33:00 GMT

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

Variable

jvitantonio — Tue, 13 Mar 2012 13:36:53 GMT

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

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

Variable

bharatkishore — Tue, 13 Mar 2012 13:39:37 GMT

Thannks a lot

Variable

bharatkishore — Tue, 13 Mar 2012 13:53:09 GMT

HI Celambarasan,

I tried but i am getting value as 0.

Variable

CELAMBARASAN — Tue, 13 Mar 2012 14:08:42 GMT

Hi,

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

Celambarasan

Variable

bharatkishore — Tue, 13 Mar 2012 14:14:49 GMT

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.

Variable

CELAMBARASAN — Tue, 13 Mar 2012 14:20:49 GMT

Hi,

Then Assign vData1 value as =vData

Celambarasan