topic Re: when a calculated dimension is null the next columns dimension are hide in QlikView

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

Tue, 18 Dec 2012 08:50:37 GMT

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

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

sujeetsingh — Tue, 18 Dec 2012 08:59:40 GMT

Kinney,

Your explanation is uncomplete..

Can you please tell what object are you using..

Why dont you post a sample.. if possible?

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

Miguel_Angel_Baeyens — Tue, 18 Dec 2012 09:03:05 GMT

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

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

Tue, 18 Dec 2012 10:07:03 GMT

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

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

Tue, 18 Dec 2012 11:24:52 GMT

Hi.

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

many thanks.

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

Miguel_Angel_Baeyens — Tue, 18 Dec 2012 12:07:02 GMT

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

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

Tue, 18 Dec 2012 12:51:20 GMT

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

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

Miguel_Angel_Baeyens — Tue, 18 Dec 2012 13:52:37 GMT

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

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

Tue, 18 Dec 2012 14:32:13 GMT

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

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

Miguel_Angel_Baeyens — Tue, 18 Dec 2012 14:37:16 GMT

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

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

Tue, 18 Dec 2012 14:48:52 GMT

no, nothing :-((

ut you also remove aggr in the expressions?

But I don't understand because if i don't filter all dimensions appears while, after filter, some dimensions hide.

if there aren't any solution i'll try to calulate all directly in the query.

Regards

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

Tue, 18 Dec 2012 15:03:01 GMT

Now works.

in dimension (also in Surface and Qty column) instead of if isnull() i use if(AGGR(count(Field), NODE)=0,'-',field) and all columns apperas also when filter is active.

Many thanks for your help