Discussion Board for collaboration related to QlikView App Development.
We are facing one small problem while do binary load.
we needs to do filter some data based on the condition while do binary load..
for this, i gone through many of our threads , but we counldn't get result..please advice..
Load data through binary load
in that, filter all current month data or show data only till previous month..
we are using common DM (Data model) for two applications..so not able to filter the data in DM itself.
Thanks and regards,
There is no possibility to filter a binary-load. But you could after them loading your tables again with where-clauses and/or dropping fields and tables - and of course you could also add new data.
View solution in original post
let we try that.
- at the end of the DM qvw store the tables in .qvd files and in the 2 applications use different filters in the where section of the load
- after binary load you can do a (noconcatenate) resident load with a where filter on the date field, then drop the original table
- after binary load you can create a table with the needed dates (or months) and use right keep to filter
Hope it helps