topic Re: How to display column value based on parameter selection in QlikView

How to display column value based on parameter selection

Tue, 23 Jun 2015 05:59:03 GMT

Dear Experts ,

I want to display column value based on combination of parameter selection , i have a job table with 5 columns (Job date , agent name , shipper name , consignee name , no of shipments). My requirement looks very simple , just need to display 4 columns in report except job date based on parameter selection .

My Parameter values are Date filed , New shipper , New consignee , existing shipper , existing consignee .

If i select parameter Date as 1st June , New shipper and Existing Consignee , i want to display agent wise report based on date range with new shipper and existing consignee . where shipper field value should be new and does not exist before 1st jun and consignee should be an existing one before 1 st jun .

i am using below expression , but not getting exact output , i have attached a screen shot of design , please suggest .

=if(SHIPPER = 'New' and CONSIGNEE = 'Existing' and len(if(max(JOB_DATE) >= '01-JUN-2015' and max(JOB_DATE) <= SYSDATE ,Shipper))>0 and len(if(min(JOB_DATE) < '01-JUN-2015',Shipper))=0,

and len(if(min(JOB_DATE) < '01-JUN-2015',Consignee))>0 ,SUM(aggr(NO_OF_SHIPMENT,Shipper,Consignee)))

Re: How to display column value based on parameter selection

jonathandienst — Tue, 23 Jun 2015 06:09:30 GMT

It would be best if you could supply a sample qvw illustrating your issue. Without the sample its mostly guessing...

What is SYSDATE? This is a SQL keyword, not Qlikview. You probably need Today() instead.
Are your dates proper QV dates? See Why don’t my dates work?
I don't understand what you are trying to do with len()?

Re: How to display column value based on parameter selection

Fri, 26 Jun 2015 09:37:34 GMT

Dear Experts ,

Kindly check my attached image and QVW file . I want to display New Shipper , New Consignee else existing shipper new consignee based on parameter selection .

In my example i have an Date range value from 1st Jan 2014 to 21st Jan 2014 , But my date selection is from

09-JAN-2014 to 21-JAN-2014.

If i select New shipper and new consignee combination , then i want to show shipper and consignee should not exist before 09th jan .

If i select Existing Shipper and New Consignee , then shipper should not exist after 9th jan and Consignee should not exist before 9 th jan .

My requirement looks simple , as i new to qlik , i cant able to handle this is in expression or add calculated dimension,

Kindly suggest .

Re: How to display column value based on parameter selection

Tue, 21 Jul 2015 07:15:35 GMT

Dear Experts ,

Could you pls help me on above request .