topic Re: Script : values from rows to columns (fields) in QlikView

Script : values from rows to columns (fields)

Thu, 05 Nov 2015 16:07:34 GMT

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.

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

settu_periasamy — Fri, 06 Nov 2015 03:38:24 GMT

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..

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()

));

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

Anonymous — Fri, 06 Nov 2015 03:56:29 GMT

Hi,

Transpose the fields.

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

Anonymous — Fri, 06 Nov 2015 03:58:34 GMT

Have a look:

Transpose Table

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

jagan — Fri, 06 Nov 2015 06:02:39 GMT

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.

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

Fri, 06 Nov 2015 08:25:50 GMT

Hi, thanks a lot for your helpful advice!

Best regards,

Flavio