Qlik Community

Qlik Sense App Development

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

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist
Specialist

Re: Auto generate fixed nbr of columns and rows?

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.
Highlighted
MVP & Luminary
MVP & Luminary

Re: Auto generate fixed nbr of columns and rows?

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

Highlighted
Specialist
Specialist

Re: Auto generate fixed nbr of columns and rows?

Thank you again Marcus!