topic Re: Test on 2 empty dimensions in QlikView

Test on 2 empty dimensions

maxime66 — Fri, 21 Aug 2015 13:55:03 GMT

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.

Re: Test on 2 empty dimensions

jonathandienst — Fri, 21 Aug 2015 14:02:39 GMT

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)

Re: Test on 2 empty dimensions

pokassov — Fri, 21 Aug 2015 14:03:41 GMT

Hi!

Change dimension

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

Re: Test on 2 empty dimensions

maxime66 — Fri, 21 Aug 2015 14:18:01 GMT

Perfect guys !

thanks.

Re: Test on 2 empty dimensions

sasiparupudi1 — Fri, 21 Aug 2015 14:20:24 GMT

another way could be as attached

hth

Sasi