topic Re: Maximum Column in QlikView

Maximum Column

Tue, 17 Jul 2012 11:43:51 GMT

Hi everyone.

I am trying to run a loop that will go from column 3 till the last coumn. The last column number will however vary, therefore I needed to know if there is a command to find the last column of a table please?

Regards,

Ashley.

Re: Maximum Column

jvitantonio — Tue, 17 Jul 2012 11:57:55 GMT

Hi,

Use

NoOfColumns([ total ] )

Re: Maximum Column

Tue, 17 Jul 2012 12:08:08 GMT

Maybe you can use NoOfFields to get the number of columns in a table.

LET vNcolumns= NoOfFields('Table name');

Re: Maximum Column

Tue, 17 Jul 2012 12:16:23 GMT

Hi.

Thank you.

Our user has changed some of their requirements now but I will try it should I still need it.

Regards,

Ashley.

Re: Maximum Column

Tue, 17 Jul 2012 12:17:51 GMT

Hi.

Thank you.

Our user changed her requirement so if I still need it, I will try it out.

Regards,

Ashley.