Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Need to combine two field values to one field with condition.

Hello Team,

Can any one help me on this, I have 2 fields present in my dataset, Please find the below example,


and I want to make it as one field like if (Order ID1 is not blank then orderID1 else orderID2.


expecting output like below.




Thanks in Advance


Labels (1)
  • Other

1 Reply

Best to do this in the load script. 

if(len(orderID1) > 0, orderID1, orderID2) as SalesOrderId

If the fields are in different tables and you have questions about how to go about it, please post an image of your data model.