parameter combination checking

[#1]

Dear Experts ,

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 .

Please suggest

Sample output for new shipper selection  :

Shipper    consignee    shipment

C             Z                2

B             U                1

C            M                 1

E            Z                  1

F           K                  2

G            J                 1

[#2]

Dear Experts ,

Any help on my above request ....

[yura_ratu]

Hi Sciram,

Take a look on this file

I've made changes in dimensions of straight table

[#4]

Hi Yurii ,

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

Please suggest .

[yura_ratu · Accepted solution]

Hi Sciram,

See attached. I've made changes in a script (added key for shipper-consignee combination), and made aggregation in OLD Method table  dimensions based on this new field

[#6]

Thanks a lot yurii