Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
serder_uenlue
Contributor
Contributor

Divide field values and invite them to a new field

Post translated by Qlik Community Team using Google Translate.

Only post in English on the Qlik Community, unless you are in a language specific forum.

----

Hallo Community,

I would like to know how I share field values from a field. Have the field "articles" loaded from an SQL database, now I would like to load the digits 1 to 26 and 100 from this field gladly in a new field with the field designation "additional positions".

Does anyone have a solution!

Best regards

3 Replies
oknotsen
Master III
Master III

Can you let me know which Qlik product you are using (QlikView or Qlik Sense) so I can move this topic to the correct forum?

Thank you.

May you live in interesting times!
serder_uenlue
Contributor
Contributor
Author

I am using QlikView!

Miguel_Angel_Baeyens

If you are loading a position based field, then the way of doing it would be like

LOAD [@1:26] AS Field1,

[@100:100] AS Field2

FROM...