Customers - where i load all customers from data base
Sales Ledger - where i load all info about customer sales data
Payment Ledger - where i load all info about customer payment data
All 3 tables are linked together via CustomerCode that is in all 3 tables.
My problems is that i loose records if customer has an invoice(Sales Ledger table) but has never made a payment(Payment ledger table). And finally calculating all the debts i miss that data because according to qlikview architecture i get only asociative data from all 3 linked tables.
Any body has an idea how i should not loose data in this way.
Sorry i forgot to remove Module password. Now it is removed see attached file. Basically what that macro does it sets the vmindate and vmaxdate variable values to empty after i press the clear button. If you select sheet payments and select that good customer and you can see i have 2 calendar objects where users can define the between date of payments which are controlled by variables. I didn't figure it out how to clear those variables after i press the clear button so found this nasty example somewhere and seems that it is messing something that i don't understand now. It should anyway set the date to nothing. Yes if you comment this macro all is working ok except then how should i clear those 2 calandar fields together with button clear?
Thanks for response i finally got it to work bit in a bit different way. On the calendar on the date to where it is controled by max date variable i had i macro on input and on the clear event i had another macro which was setting the variables to "" but it was not releasing the field Ndate which acts as a between dates values so i had like an active selection Ndate<=>= and it was causing that error. Thank you for help.
