This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Just a clarification are the two statements allowed in qlikview?
If (RPAD("REPORTTYPE", 4) = 'PAID' , 'MDR PAID')
thanks in advance
I've never seen them but check the F1 help. What are you trying to do? There's probably another function that will suit...
To convert to text you can use TEXT function. TEXT(GTS_SHORT_IBT)
And you can use repeat function to have your values padded :
REPEAT('0', (10 - LEN(MYVALUE))) & MYVALUE AS NEWFIELD
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!