Discussion Board for collaboration on QlikView Scripting.
Last try simple way
I have 2 tables one with fields- Primary key SID, warrstart, warr end end and other table with con start, con end
Warr end was limited to current fiscal year 2013
Duplicates issue after resident load of max warr end and min constart
Example- when I join 2 tables
There are 3 same sids with warrstart, warrend dates following constart, conend dates for diff con_types
-Show me only max warend and a following min contract start date and there corresponding records for each sid and dont show other records
When I try to test only one table for max warr start date then also I am getting duplicates
In this case its picking max warr end but also all warr start dates which is not right it should be corresponding date for for max warr start date
I am using resident loads for max warr end and min con start for each table
Please help .................
Thanks in advance
I think it would be easier if you post your input data (or a sample / mock up of the data), and your requested results made out of the input.
I attached a Sample QVW check it out
Output should be 1st criteria MAX WARR END DATE following MIN CONTRACT START DATE and corresponding dates
not supposed to get any duplicates but in the sample u can see some duplicates