topic Making one row into severals in QlikView

Making one row into severals

martinqlik — Thu, 10 May 2018 14:06:24 GMT

Hello Qlikers,

Actually, I have a table that comes all data into one single line, like below:

FISCAL DOCUMENT ITEM 1 ITEM 1 QTY ITEM 2 ITEM TWO QTY ITEM 3 ITEM 3 QTY

999999328 83.402.00152-8b 3 85.110.00140-1b 1 85.110.00141-8b 5

I would like to show data in this model:

FISCAL DOCUMENT ITEMS QTY

999999328 83.402.00152-8b 3

85.110.00140-1b 1

85.110.00141-8b 5

It must be done in the script. I have tried Crosstable prefix, but it doesn't working properly.

Does anyone knows how to get it?

Re: Making one row into severals

sunny_talwar — Thu, 10 May 2018 14:09:29 GMT

Can you share what you have tried thus far? It sometimes helps to see what you have done to explain what you might be doing wrong.

Re: Making one row into severals

martinqlik — Thu, 10 May 2018 14:13:22 GMT

Hello,

I didn't get properly the right way for doing that development. I have an ideia that can be done by using Crosstable prefix, but I have never developed in such a way.

Thank you.

Re: Making one row into severals

vishsaggi — Thu, 10 May 2018 15:03:54 GMT

May be one way could be like

CrossTable(ITEMSLIST, QTY)

CrossTab:

LOAD FISCALDOCUMENT,

ITEM1&'|'&ITEM1QTY,

ITEM2&'|'&ITEM2QTY,

ITEM3&'|'&ITEM3QTY

INLINE [

FISCALDOCUMENT, ITEM1, ITEM1QTY, ITEM2, ITEM2QTY, ITEM3, ITEM3QTY

999999328, 83.402.00152-8b, 3,85.110.00140-1b,1,85.110.00141-8b,5

];

NoConcatenate

Final:

LOAD FISCALDOCUMENT,

Subfield(QTY, '|',1) AS ITEMS,

Subfield(QTY, '|',2) AS QTY

Resident CrossTab;

DROP TABLE CrossTab;

Re: Making one row into severals

martinqlik — Thu, 10 May 2018 17:37:30 GMT

It worked.

Thank you,