topic Re: Key on CrossTable in QlikView

Key on CrossTable

Fri, 22 May 2015 03:35:47 GMT

Hi,

I have a question, i have load data with CrossTable like this one :

Transform:

CrossTable(LEVEL , VALUE)

LOAD NAME,

LEVEL&VALUE as key

FROM

......

I want to make LEVEL and VALUE field as a KEY for example LEVEL "A" and VALUE "1", so the KEY will be "A1". how can i make a key from crosstable field.

I really need your help.

Thanks, i really appreciate your help

Regards,

Indra

Re: Key on CrossTable

danieloberbilli — Fri, 22 May 2015 04:13:52 GMT

Not sure if this is what you are looking for...but a possible approach:

Data:

LOAD * INLINE [

NAME, A, B, C

John, 50, 10, 23

Richard, 10, 10, 25

Sean, 20, 200, 22

];

Transform_tmp:

CrossTable(LEVEL , VALUE)

LOAD

NAME,

// LEVEL&VALUE as key

Resident Data;

Transform:

LOAD

NAME,

LEVEL,

VALUE,

LEVEL &'_'& VALUE as key

Resident Transform_tmp;

DROP Table Transform_tmp;

Re: Key on CrossTable

Fri, 22 May 2015 04:21:28 GMT

Hi Daniel,

Wow, really thanks for your help. It solved my problem.

Super thanks Daniel.

Regards.

Indra

Re: Key on CrossTable

Fri, 22 May 2015 05:22:38 GMT

it's good idea Daniel.

Ramya.