topic How to visualize orders... in QlikView https://community.qlik.com/t5/QlikView/How-to-visualize-orders/m-p/733664#M537532 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P>I have a list of orders with different status. An order may have the status "Received", "Active", "Approved". </P><P>Received means that the order is received but not reviewed by staff. A time stamp for this is available.</P><P>Active means that the order is being reviewed by staff. Time stamp available.</P><P>Approved means that the order is approved by staff and this starts different processes. Time stamp available.</P><P>There is an internal target that all orders should be approved within 24 hours. That is the time from "Received" to "Approved" is maximum 24 hours.</P><P></P><P>The requirement is to visualize the orders in three categories:</P><P>1 - All orders with less than 8 hours until deadline. Deadline is 24 hours from Received time stamp.</P><P>2 - All orders with more than 8 hours until deadline.</P><P>3 - All orders that passed deadline.</P><P></P><P>There is also a requirement of showing the value ($) of the orders. I was thinking of showing different colors for different values in some way.</P><P></P><P>Well my first thought was to create a bar chart with three bars - one for each point above and have different colors on the bars representing the value. A red color that gets darker if the total value of the bar is higher.</P><P></P><P>My question is: do you have any suggestion how to visualize this in other ways?</P><P></P><P>All ideas are appreciated.</P><P></P><P>Br</P><P>Cris</P></BODY></HTML> Wed, 15 Oct 2014 16:04:07 GMT mr_novice 2014-10-15T16:04:07Z How to visualize orders... https://community.qlik.com/t5/QlikView/How-to-visualize-orders/m-p/733664#M537532 <HTML><HEAD></HEAD><BODY><P>Hi All!</P><P>I have a list of orders with different status. An order may have the status "Received", "Active", "Approved". </P><P>Received means that the order is received but not reviewed by staff. A time stamp for this is available.</P><P>Active means that the order is being reviewed by staff. Time stamp available.</P><P>Approved means that the order is approved by staff and this starts different processes. Time stamp available.</P><P>There is an internal target that all orders should be approved within 24 hours. That is the time from "Received" to "Approved" is maximum 24 hours.</P><P></P><P>The requirement is to visualize the orders in three categories:</P><P>1 - All orders with less than 8 hours until deadline. Deadline is 24 hours from Received time stamp.</P><P>2 - All orders with more than 8 hours until deadline.</P><P>3 - All orders that passed deadline.</P><P></P><P>There is also a requirement of showing the value ($) of the orders. I was thinking of showing different colors for different values in some way.</P><P></P><P>Well my first thought was to create a bar chart with three bars - one for each point above and have different colors on the bars representing the value. A red color that gets darker if the total value of the bar is higher.</P><P></P><P>My question is: do you have any suggestion how to visualize this in other ways?</P><P></P><P>All ideas are appreciated.</P><P></P><P>Br</P><P>Cris</P></BODY></HTML> Wed, 15 Oct 2014 16:04:07 GMT https://community.qlik.com/t5/QlikView/How-to-visualize-orders/m-p/733664#M537532 mr_novice 2014-10-15T16:04:07Z