Discussion board where members can get started with QlikView.
I have following data as
but i want see this kind of output
Please help me out
Probably you can simplify it a bit, I tried to create a more generic approach:
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.
if(Right(Left(Field,3),1) = '.', Mid(Field,4), Field)
Hope it helps
You'll probably want to wrap a text() around it so the results display left justified.