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 where members can learn more about Qlik Sense App Development and Usage.
I have ID numbers
i want to show it as
Before id i have to add Text as TNN00000
For example:- ID 1 ====> show as ====> TNN000001
ID 2 ==================> TNN000002
ID 10 =================> TNN000010
ID 111================> TNN000111
ID 1213================> TNN001213
IF the digits increased then we have to decrease the Zeros
after TNN required six Numbers
I have to show in ID value digit's increases then the zeros have to decreased as shown in the above example
Thanks & Regards,
Load using this:
'TNN'&Num(ID, '000000') as TNNID
you can take this a step further
Thanks to both of you