topic Re: Conditional dimension in pivot table in QlikView

Conditional dimension in pivot table

Tue, 06 Oct 2015 07:27:20 GMT

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!

Re: Conditional dimension in pivot table

avinashelite — Tue, 06 Oct 2015 07:30:47 GMT

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

Re: Conditional dimension in pivot table

vipin_mishra479 — Tue, 06 Oct 2015 07:38:22 GMT

Hey Thibaut,

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

Re: Conditional dimension in pivot table

Tue, 06 Oct 2015 08:13:33 GMT

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)