I have three tables and I would like to join these table for the aggregation purpose.
My purpose is to show which Ac_No are belongs to which Department. But I would like to show only Ac_No in Customer Account(20698586763665702) these have same Reference_No and not to show in (330601017). Hope to help me.
When you load data into QlikView it will automatically join table with a full outer join based on common field names. In your case you have common field names (Ac_No and Department) all you need to do is load the data. I would highly recommend you take a look at Creating a Data Model video and the other New to QlikView Videos