Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

parameter combination checking

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: parameter combination checking

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

View solution in original post

5 Replies
Highlighted
Not applicable

Re: parameter combination checking

Dear Experts ,

Any help on my above request ....

Highlighted
Partner
Partner

Re: parameter combination checking

Hi Sciram,

Take a look on this file

I've made changes in dimensions of straight table

Highlighted
Not applicable

Re: parameter combination checking

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 .

Highlighted
Partner
Partner

Re: parameter combination checking

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

View solution in original post

Highlighted
Not applicable

Re: parameter combination checking

Thanks a lot yurii