topic Text manipulation in QlikView

Text manipulation

Mon, 01 Aug 2016 15:48:34 GMT

I have a table called Inventory Master, within this table there is a column called 12 month usage. The problem I am having is that the 12 month usage column combines all 12 months separated by a space. I need to be able to break the data up into separate columns so I can show each month in it's own field. Any input or assistance would be greatly appreciated.

Re: Text manipulation

Gysbert_Wassenaar — Mon, 01 Aug 2016 16:12:10 GMT

Perhaps you can use the subfield function:

LOAD

...some fields...,

SubField([12 month usage], ' ') as [month usage],

...some more fields...

FROM

....source....

;

LOAD

...some fields...,

SubField([12 month usage], ' ',1 ) as [month usage 1],

SubField([12 month usage], ' ',2 ) as [month usage 2],

....etc

SubField([12 month usage], ' ',12 ) as [month usage 12],

...some more fields...

FROM

....source....

;

Re: Text manipulation

Mon, 01 Aug 2016 16:38:24 GMT

Hey Robert,

As Gysbert mentioned SUBFIELD is an answer here.

If I can suggest something: - If you are planning to create charts using this dataset, consider using The Crosstable Load on top of data generated by Gysbert's script. Having all months as one dimension will make your life much easier

BR,

Kuba

Re: Text manipulation

Mon, 08 Aug 2016 12:19:35 GMT

Worked like a charm. Thank you.

Robert Galloni

Information Technology Director