Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
master_student
Creator III
Creator III

Condition

Hello Guys,

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

Capture.PNG

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

Capture.PNG

1 Solution

Accepted Solutions
YoussefBelloum
Champion
Champion

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)

View solution in original post

3 Replies
YoussefBelloum
Champion
Champion

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
Creator III
Creator III
Author

Thanks youssef, you are right

YoussefBelloum
Champion
Champion

You're welcome