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.
