I am designing a simple report , but am i new to qlik , feel little difficult to achieve this .
In my report , i have 3 parameter , new shipper , new consignee , new shipper consignee and my date selection between
01-jul-15 to 31-jul-15 . if i select new shipper , then based on job date i want to display new consignee in consignee column where consignee should not exist before from date , in shipper column i want to display shipper (existing or new shipper) ,when that shipper is new to particular consignee with in a date limit .
If i select new consignee , its exactly opposite condition on above .
if i select new shipper consignee , then both shipper and consignee will be new and should not exist before from date .
Thanks for your reply , its really helpful . A small changes in report , but cant able to get exact output .
If i select New shipper or New Consignee in parameter , i want to check shipper consignee combination .
If shipper and consignee combination already exist before from date , i need to hide that record .
If i select NEW shipper consignee parameter , i want to display only new shipper consignee combination , which that combination should not exist before from date .
In my example i have selected new shipper as parameter , it displaying totally 7 records , but out of 7 , i want to display only 5 , because shipper B consignee G and Shipper C Consignee F combination is already exist before 1 st jul 2015