Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Need Help - Create dynamic columns & rows

Hello All,

I have requirement to convert the data from Table 1 to Table 2 in QV 11 SR1  as shown in screenshot, number of Rows in Table 1  is dynamic, means column creation of Table 2 in qlikview witll be dynamic as well.

Transpose_Dynamic.png

I am really new in Qlikview and will appreciate any guidance.

Thanks,

Pooja

4 Replies
Not applicable

Re: Need Help - Create dynamic columns & rows

Any inputs please ?

Re: Need Help - Create dynamic columns & rows

It's a very bad idea and I have no idea why you would ever want to do that, but this should do what you want:

T2:

load RowNo() as id, * inline [

Name, Value

Chipset,Chip 1

Chipset,Chip 2

Chipset,Chip 3

Modem,Mod 1

Modem,Mod 2

Wireless,Wir 1

Wireless,Wir 2

];

 

T3:

load RowNo() as id, Value as Chipset

Resident T2 where Name = 'Chipset';

join(T3)

load RowNo() as id, Value as Modem

Resident T2 where Name = 'Modem';

join(T3)

load RowNo() as id, Value as Wireless

Resident T2 where Name = 'Wireless';

drop field id;

drop table T2;

You can replace the inline load with a load statements that load your Table 1 data.


talk is cheap, supply exceeds demand
Not applicable

Re: Need Help - Create dynamic columns & rows

Thanks Gysbert for your response. It will work , if the Name field value are constant.

Solution of this problem become much simpler with  the updatde requirements.

Was able to achieve it by using Pivot Table , Name as Dimension & value as expression.

jeffmartins
Contributor II

Re: Need Help - Create dynamic columns & rows

Hi poojasaxena,

I've had a problem similar with yours about creating fields dynamically and I solved it using the code of the attached file.

Hope this helps you.

Regards

Community Browser