topic Help needed in expression in QlikView

Help needed in expression

Mon, 18 Nov 2013 13:04:48 GMT

Hi All,

I have data in this format {"Marks":"95"},inorder to take the values 95 alone i used the expression

=subfield(columnname,':",3)but it does not return the value 95

Kindly help me in getting this value 95 alone

Thanks in advance

Re: Help needed in expression

Clever_Anjos — Mon, 18 Nov 2013 13:08:27 GMT

=keepchar(subfield(columnname,':",2),'0123456789')

Re: Help needed in expression

stantrolav — Mon, 18 Nov 2013 13:09:53 GMT

=right(3,2)

this would get you 2 digits from right, starting at third digit from right.

Re: Help needed in expression

swuehl — Mon, 18 Nov 2013 13:09:53 GMT

Why do you use 3 as argument to subfield (where I would expect 2)?

If you then get

95"}

you might use an additional purgechar():

=subfield(purgechar(columnname,'{}""'),':',2)

Re: Help needed in expression

stantrolav — Mon, 18 Nov 2013 15:19:22 GMT

And what is the answer? ashoksenthilcould you do smth with this theme? There are lots of questions here Not Answered. Don't leave one more among them.