I have weekly extracts loaded, where all the history of the records(ID) loaded. App has 14 reports and contains pivot tables, tables, text objects (calculations) and also built Master calendar on Last_Modified_Date .
Now I need to build the app with the date filter in such a way that -
1. Once the app is opened - it should show only the records ID's with the max(Last_Modified_Date)
2. When user applies filter .. say 'Dec-2107', app should show only Dec-2017 ID's, which have max(Last_Modified_Date) record. Please note: Since it is a weekly extract - A record might be modified 4 times a particular month. So it should only pick the latest record.
1) You can assign OnOpen Trigger From "Document Event Triggers"
2) Qlikview Handle this if Data model is Correct ..
Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
