Test on 2 empty dimensions

[maxime66]

Hy guys,

Someone knows where my test is wrong ? (see Qlikview attached)

it returns nothing '-'  when testing if both dismensions are null.

best regards.

max.

[jonathandienst · Accepted solution]

That expression: =if(isnull(client_lieu_gestion.libelle) and isnull(apporteur.nom) , 'null','not null')

does not work as a dimension. It does work as expected when used as an expression and not a dimension. To use as a dimension, use an Aggr() like this:

=Aggr(if(isnull(client_lieu_gestion.libelle) and isnull(apporteur.nom) , 'null','not null'),apporteur.nom,client_lieu_gestion.libelle, contrat.id)

[pokassov]

Hi!

Change dimension

=aggr(if(isnull(client_lieu_gestion.libelle) and isnull(apporteur.nom) , 'null','not null'),contrat.id)

[maxime66]

Perfect guys !

thanks.

[sasiparupudi1]

another way could be as attached

hth

Sasi