when a calculated dimension is null the next columns dimension are hide

[#1]

Hi,

Sometimes when a calculated dimension is null the next column dimension doesn't appears and i don't know why.

i try to put the condition if(Isnull(field) ,'-',field) on alld imension but doesnt work's.

someone can help me?

Many thanks for your supports

[sujeetsingh]

Kinney,

Your explanation is uncomplete..

Can you please tell what object are you using..

Why dont you post a sample..  if possible?

[Miguel_Angel_Baeyens]

Hi,

Actually, you can mark the check "Show All Values" in the chart properties, Dimensions tab. That should show all values in dimensions. In addition, make sure that in the chart properties, Presentation tab, "Suppress Zero Values" and "Suppress Missing" are unchecked, so even if null values are there, they will be showed.

I'd do something similar to what you are doing in the script, using instead of IsNull():

Table:
LOAD // rest of fields here
     If(Len(Trim(Field)), Field, '-') AS Field // Len() and Trim() instead of IsNull()
FROM // Source here

So you will always have a value in the field after reloading.

Hope that helps.

Miguel

[#4]

you are right:

I use Pivot chart.

yes i unchecked in Presentation tab, "Suppress Zero Values" and "Suppress Missing".

i'll try to create a sample to attach.Now the reports have too many data and Sensible Data.

many thanks

[#5]

Hi.

here the example.try to select one mark-spool from the list box and some columns hide.

many thanks.

[Miguel_Angel_Baeyens]

Hi,

If I select "--7B" and I see all columns in the table, but some of them show "-" (null). That's the behavior I'd expect. What's wrong with that or what should I do to reproduce your issue?

Miguel

[#7]

Hi,

If i select "--7B" i have this grid(I attach a screen) without column Qty,%, etcc 😮 it's very strange.

many thanks for your support

[Miguel_Angel_Baeyens]

Ah, Ok, My fault,

Then it's not because of the null, but because of the Aggr() functions in the calculated dimensions. In the % dimension, for example, you are using Aggr() but only with NODE, you should add all the fields in the dimensions tab as well.

Hope that helps.

Miguel

[#9]

thanks.for your help and your patience 🙂

But i need to do the aggr functio by node and so i think i can't rempove this condition..

For thest I try to remove all dimensions with Aggr function(so the last dimension is 'Qty Kg' column) but the same problem persist.I see only "Surface  (m2)" dimension but not the Qty Kg'.

many thanks

[Miguel_Angel_Baeyens]

Hi,

If I remove all Aggr() functions, I do see the Qty Kg column selecting that "--7B" value.

Did you change anything in the file above?

Miguel