This content has been marked as final. Show 4 replies
Let's say I have two tables:
These two tables are linked together by a One to Many (Order list 1 - * OrderDetails) relationship by Order_Id.
What I'd like to do is to create a calculated field in OrderDetails, such that
IF(Order_Start_Date < Order_End_Date, 'Right', 'Wrong') .
It would be easy to do that in the OrderList table, but how could I do it in OrderDetails?
I am coming from another BI Software and I was used to work this way.
Is it possible with Qlik Sense or do I have to merge the two tables in the script editor and create a single table?
In the data editor I can choose only the fields ot the table I am currently working on.
Many thanks to everyone who may give me some hints about this!