topic Re: Show column if limitations in App Development

Show column if limitations

wbelton — Thu, 05 May 2022 19:07:01 GMT

Does anyone know if there is a limit to the 'show column if' functionality? It seems to break for me at 30 columns. I have a possibility of around 100 potential columns that could be displayed. All the columns display when no value is selected in the filter. Once a single value is selected, then 5 columns pertaining to that value will display. Everything works through 6 selections (30 columns). As soon as I select a 7th value, all 30 of the columns disappear and only the columns not utilizing the 'show column if' functionality still appear. It seems to be a limit in Qlik, but curious if anyone else has seen the same problem.

Re: Show column if limitations

vchuprina — Thu, 05 May 2022 20:24:45 GMT

Hi,

check your conditions, maybe write them in another way. I met limitation one time, when customer asked to add around 400 columns to the table (not sure why he needed so many columns). Once I added 257 columns to Straight table I saw that conditions doesn’t work as expected, the same problem happened with pivot when I added 129 columns. So based on my experience limitation for straight table is 256 columns and for pivot 128.

Regards,

Vitalii

Re: Show column if limitations

enricocamerin — Thu, 04 Jul 2024 15:33:55 GMT

I have the same problem, after 6 condition all the column disappear expect the ones without show if condition