Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
swarup_malli
Specialist
Specialist

Auto generate fixed nbr of columns and rows?

 

 

Hi All,

 

 

There is a floor with the dimension 141 * 50 ( lenght * breath).

 

I want to create a table that resembles the above floor  wihth 141 columns and 50 rows.

 

The column should start with A,B........AB,AC.......so on and the rows should start from 1 to 50.

 

In essence I'm trying to create a grid using a table object

 

 

Labels (2)
12 Replies
swarup_malli
Specialist
Specialist
Author

In the generated series i do not see AZ , BZ,CZ.....IZ..

Instead AY is followed by AA .. same for BY which is followed by BA.
marcus_sommer
MVP & Luminary
MVP & Luminary

For me it worked:

ColumnRowMatrix.JPG

If you are missing the Z's then it might be caused from differences between my default regional-settings (OS) and/or the used char-sets respectively collation-settings and your configurations. Maybe you could adjust them in any way.

Deducing from this it indicates that in your char-list is any additional/different char compared to my "standard" alphabet. To know it might be useful for any adjusting approaches to the settings.

An alternatively might be just to increase the number of chars by using 27 instead of 26, like:

t1: load *, 1 as ID, chr(64 + if(Cluster = 1, null(), Cluster -1)) & 
chr(64 + recno() - ((Cluster - 1) * 27)) as Column; load ceil(recno() / 27) as Cluster autogenerate 141;

- Marcus

swarup_malli
Specialist
Specialist
Author

Thank you again Marcus!