topic Expression issue in QlikView

Expression issue

Mon, 11 Jun 2012 19:21:34 GMT

I have following data as

01.01

01.02.01

02.02.02

02.02.03

but i want see this kind of output

02.01

02.02

02.03

Please help me out

swuehl — Mon, 11 Jun 2012 19:38:16 GMT

Probably you can simplify it a bit, I tried to create a more generic approach:

=Left('01.02.03.04.05',2)&mid('01.02.03.04.05',3,3*(SubstringCount('01.02.03.04.05','.')-1))

resp.

=Left(FIELD,2)&mid(FIELD,3,3*(SubstringCount(FIELD,'.')-1))

edit:

Need to get my eyes checked. Just noticed that my expression will return the left part of your sample data, that's not what you asked for.

MayilVahanan — Mon, 11 Jun 2012 21:50:51 GMT

hi,

Try this,

if(Right(Left(Field,3),1) = '.', Mid(Field,4), Field)

Hope it helps

rwunderlich — Tue, 12 Jun 2012 05:37:57 GMT

How about:

=mid(X, index(X,'.')+1)

You'll probably want to wrap a text() around it so the results display left justified.

=text(mid(X, index(X,'.')+1))

-Rob