topic Matching a field selection to another field set Expression in QlikView

Matching a field selection to another field set Expression

Tue, 12 Mar 2013 00:49:24 GMT

Hi Guys,

I'm trying to create the following tables. The expression I want is to sum up the revenue where the Dimension is equal to either the Shipper or Consignee Name.

The only way I've though of to do this was using a data island, however both these fields are quite large, I would like to avoid duplicating this data in a data island if possible. Any suggestions? An example would be for the dimension "Credit Valley Hospital" the expression should sum up all revenue where "Credit Valley Hospital" is the Shipper or Consignee. Thanks in advance.

Re: Matching a field selection to another field set Expression

pauljohansson — Tue, 12 Mar 2013 14:47:54 GMT

Hi,

If I understood you right you should be able to "tag" your data by adding a column specifying if the data is "Shipper" or "Consignee Name"

Then you should be able to concatenate your tables creating ONE table looking something like:

Charge Type Name

100 Shipper Credit Valley Hospital

Paul