Conditional dimension in pivot table

[#1]

Hi All,

I encounter a very strange behavior with our Qlikview version 11.00 SR1.

I have a little pivot table with 5 dimensions and conditional display (pick dimension).

On my PC the table is displaying like a charme but on access point I have a cross inside the table like a memory calculation limit.

I tried to change the table in a straight table and it works on access point.

I don't understand and I would to know if the community has already encountered this issue.

Thank you in advance for your help!

[avinashelite]

if you have  calculated dimension this might happen some time because of the memory issues. Try to do all the calculation in the script and use the same in chart , this will help you overcoming the limitation

[vipin_mishra479]

Hey Thibaut,

Aviansh is correct Try to do all the calculation in the script.

[#4]

Hi both,

Thank you for your reponse.

I have any calculated dimension, I use only a conditional display with my pick dimension.

My diplay conditions are set in a variable like if(SubStringCount(Concat(_dimensionNo, '|'), 2),1,0)