topic Re: Padding and char conversion in qlikview in QlikView

Padding and char conversion in qlikview

Wed, 14 Nov 2012 07:49:53 GMT

Just a clarification are the two statements allowed in qlikview?

TO_CHAR("GTS_SHORT_IBT")

If (RPAD("REPORTTYPE", 4) = 'PAID' , 'MDR PAID')

thanks in advance

Jason_Michaelides — Wed, 14 Nov 2012 08:03:16 GMT

I've never seen them but check the F1 help. What are you trying to do? There's probably another function that will suit...

Anonymous — Wed, 14 Nov 2012 12:08:42 GMT

To convert to text you can use TEXT function. TEXT(GTS_SHORT_IBT)

And you can use repeat function to have your values padded :

LPAD :

REPEAT('0', (10 - LEN(MYVALUE))) & MYVALUE AS NEWFIELD

RPAD :

MYVALUE & REPEAT('0', (10 - LEN(MYVALUE))) AS NEWFIELD

Change '0' to the character you want to padd with. And change the number 10 with your field's max length.

I hope this helps!

Regards

MultiView