Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Dear Experts ,
Any help on my above request ....
Hi Sciram,
Take a look on this file
I've made changes in dimensions of straight table
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 .
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
Thanks a lot yurii