Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

surawutsae
New Contributor

Insert Data

I want to put number 18 between 602 and 0100380.

number 1number 2
6020100380602180100380

Note: This post was edited by a Community Moderator to include English translation as a courtesy.

1 Reply
undergrinder
Valued Contributor II

Re: Insert Data

Hi Surawut,

if you handle the field as text you can do it, if the position is allways the same, then try this:

=num(left(number1,3)&'18'&right(number1,7))

G.