Combining two possible field values

Fri, 07 Aug 2009 01:26:46 GMT

Hi guys,

I'm trying to combine some possible values of a single field when viewing them in a table. For example, I have a field called "Advice Status" for each Order in the database. Advice status has several possible values: Appropriate, inappropriate, moderate, indeterminate. I'm currently displaying these values in a table with an expression that counts the number of orders that falls into each category.

What I'm wondering is how can I combine two values, such as Appropriate and Moderate into a single field in the table. So when I display the table, it instead displays three possible values: Combined field (Appropriate and Moderate), inappropriate, and indeterminate.

In the end I also want to be able to combine possible values for more than one field. As in, take another field ("Action Taken" - the action by the user after receiving the advice for the order) and making composite fields based on certain combinations of ACtion taken and Advice STatus. Ie. making a count of orders that specifically have Inappropriate status and which the user then Canceled the order. I know this can be done by simply filtering the data using qlikview but I want it to be built into a table.

Dan

Combining two possible field values

prieper — Fri, 07 Aug 2009 01:43:35 GMT

Hi,

you may either apply a mapping-table or use a calculated field as dimension,

=If(Match(YourField, 'Status1', 'Status2'), 'Combined Status', YourField)

HTH

Peter

Combining two possible field values

Fri, 07 Aug 2009 02:03:32 GMT

thanks Peter

topic Combining two possible field values in QlikView

Combining two possible field values

Combining two possible field values

Combining two possible field values