topic Conditional Data on chart in QlikView https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166842#M38638 <HTML><HEAD></HEAD><BODY><P>I am extracting two fields, one being sales_order_qty, and the other stock_qty.</P><P>Can I produce a pie chart that will show only 2 figures, one where stock_qty-sales_order_qty &gt;= 0 and then where &lt;0.</P><P></P><P>I am trying to display a red/green visual indicator of sales orders that we cannot fulfil with current stock.</P></BODY></HTML> Thu, 17 Mar 2011 15:35:06 GMT 2011-03-17T15:35:06Z Conditional Data on chart https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166842#M38638 <HTML><HEAD></HEAD><BODY><P>I am extracting two fields, one being sales_order_qty, and the other stock_qty.</P><P>Can I produce a pie chart that will show only 2 figures, one where stock_qty-sales_order_qty &gt;= 0 and then where &lt;0.</P><P></P><P>I am trying to display a red/green visual indicator of sales orders that we cannot fulfil with current stock.</P></BODY></HTML> Thu, 17 Mar 2011 15:35:06 GMT https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166842#M38638 2011-03-17T15:35:06Z Conditional Data on chart https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166843#M38639 <HTML><HEAD></HEAD><BODY><P>You need to clarify your goal a little bit - are you counting products the total Sales Order Qty &gt; Stock Qty? Or Orders with those products?</P><P>What's your level of detail? Do you need to compare detailed numbers or aggregated results?</P><P>All those questions will determine the kind of solution that might help your problem...</P></BODY></HTML> Thu, 17 Mar 2011 19:24:03 GMT https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166843#M38639 Oleg_Troyansky 2011-03-17T19:24:03Z Conditional Data on chart https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166844#M38640 <HTML><HEAD></HEAD><BODY><P>What I'm trying to show by quantity is where we have enough stock to meet customer demand, so where there is enough stock those records are shown in green and where there isn't enough stock they are shown in red.</P><P>The user can then click the red records to see which parts are causing a problem.</P></BODY></HTML> Mon, 21 Mar 2011 17:11:31 GMT https://community.qlik.com/t5/QlikView/Conditional-Data-on-chart/m-p/166844#M38640 2011-03-21T17:11:31Z