topic Re: Straight Table Showing Maximum 28 columns in QlikView

Straight Table Showing Maximum 28 columns

lucas4bi — Fri, 05 Jun 2015 13:11:10 GMT

Hello Everyone,

i've created a straight table with some dimensions.

What i need to do is let the user choose some new dimensions selecting them from another field, and make the selected dimension appear in the table.

So i created this new field with the dimension names in it.

and added all the dimension in my straight table with this conditional enabler:

Index(GetFieldSelections(NewField),'MyDimension')<>0

Everything works as expected as long as the total number of columns in the Straight Table is less than 28.

When i want to add the 29th dimension, all the dimension with a conditional enabler disappear.

Why is that?

Has anybody encountered this issue?

Thanks in advance

Luca

Clever_Anjos — Fri, 05 Jun 2015 13:18:00 GMT

GetFieldSelections(NewField,',',10000) // 10.000 values as maximum

lucas4bi — Fri, 05 Jun 2015 13:24:49 GMT

Thank you! i just figured out that GetFieldSelections(NewField) was returning something like "10 of 107" instead of the complete list of the fields.

With the other parameters works properly now.