topic Re: Condition in QlikView

Condition

master_student — Thu, 28 Jun 2018 08:40:01 GMT

Hello Guys,

I need to set a condition if Fournisseur is empty like bellow then, display the values of another filed :

I create this condition =if(Fournisseur =' - ', PO_FOURNISSEUR_BCOUV) but i get nothing as a result knowing that PO_Fou:

YoussefBelloum — Thu, 28 Jun 2018 08:43:47 GMT

Hi,

usually if you make an export and see this '-', this means that it was NULL.

try this:

=if(len(trim(Fournisseur))=0, PO_FOURNISSEUR_BCOUV,Fournisseur)

master_student — Thu, 28 Jun 2018 09:07:22 GMT

Thanks youssef, you are right

YoussefBelloum — Thu, 28 Jun 2018 09:33:40 GMT

You're welcome