Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Script : values from rows to columns (fields)

Hi, I am working with the product codes in the following field:

the issue is: how can I transform these codes (rows)  in field to perform gradually some KPI between columns?

How should be done the script?

Best regards,

Flavio.

5 Replies

Re: Script : values from rows to columns (fields)

Hi,

Based on my understanding, if you have this Field in your data base, you can try to use the transpose in Transformation while Loading..

Like

Directory;

LOAD @1 as F1,

     @2 as F2,

     @3 as F3,

     @4 as F4,

     @5 as F5,

     @6 as F6

FROM

Book1.xlsx

(ooxml, no labels, table is Sheet2, filters(

Transpose()

));

qlikviewnovice
Valued Contributor II

Re: Script : values from rows to columns (fields)

Hi,

Transpose the fields.

qlikviewnovice
Valued Contributor II

Re: Script : values from rows to columns (fields)

Have a look:

Transpose Table

MVP
MVP

Re: Script : values from rows to columns (fields)

Hi,

Try CROSSTABLE()

Example:

Data:

CrossTable(Month, Budget)

LOAD

Customer,

Jan,

Feb,

Mar,

Apr

FROM Budget;

Now the resultant table is in the below format

Cutomer, Month, Budget

Hope this helps you.

Regards,

Jagan.

Not applicable

Re: Script : values from rows to columns (fields)

Hi, thanks a lot for your helpful advice!

Best regards,

Flavio

Community Browser