topic Re: parameter combination checking in QlikView

parameter combination checking

Tue, 11 Aug 2015 14:03:00 GMT

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

Re: parameter combination checking

Fri, 14 Aug 2015 14:19:54 GMT

Dear Experts ,

Any help on my above request ....

Re: parameter combination checking

yura_ratu — Fri, 14 Aug 2015 16:17:24 GMT

Hi Sciram,

Take a look on this file

I've made changes in dimensions of straight table

Re: parameter combination checking

Mon, 24 Aug 2015 11:15:11 GMT

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 .

Re: parameter combination checking

yura_ratu — Mon, 24 Aug 2015 12:42:20 GMT

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

Re: parameter combination checking

Wed, 26 Aug 2015 04:53:52 GMT

Thanks a lot yurii