Qlik Community

Ask a Question

App Development

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

Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
Showing results for 
Search instead for 
Did you mean: 
Contributor II
Contributor II

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.