Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

11 Replies
Not applicable
Author

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

Not applicable
Author

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