Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
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.