You can not control binary load: you inherit tables, their data and their relations and after that you add new tables to the model or delete those that you donot need. So what you could do is creating a NO CONCATENATE fact table from the initial one with only the data you need (WHERE Date = (Today() - 1) and later dropping the original.
I may not understand this part. Yes, You have existing file and then you have one new qvw with the load of Existing qvw by help of Binary. And then finally you need one more qvw which instance with Where condition of one day. You meant to say
I am afraid, If there is option using binary load with where condition. May be they will help us
I don't think you can limit the data using the binary load. But additional to your binary load statement you can add resident load statements.
In binary load, if you are loading data from your 'Data Model QVW' then the tables(in your Data Model QVW) are created by default in your new QVW/Dashboard once the reload done. So further, you can filter on the table that is created using Resident load statement with the filter on date column (Today()-1).