topic Re: Need to make value of a table to column name in QlikView

Need to make value of a table to column name

santhosh_k_n — Wed, 12 Mar 2014 10:19:07 GMT

Hi all,

Is it possible to make a value in one of the column to make as column name.

for ex:

I am having two columns as shown below

Now i need to present above two columns as

Please suggest

jsingh71 — Wed, 12 Mar 2014 10:54:07 GMT

Hi Santosh,

Please find attachment hope this will fulfill your need.

er_mohit — Wed, 12 Mar 2014 11:15:04 GMT

See the attached file

maxgro — Wed, 12 Mar 2014 11:19:57 GMT

REPORT:

load *, if(peek(gen)<>gen, 1, 1+peek(id)) as id;

load * inline [

gen, name

Gen1, R1

Gen1, R2

Gen1, R3

Gen1, R4

Gen1, R5

Gen2, R6

Gen2, R7

Gen2, R8

Gen2, R9

];

TABLE:

load id, name as Gen1 Resident REPORT where gen='Gen1';

join (TABLE) load id, name as Gen2 Resident REPORT where gen='Gen2';