topic Setting Goals in QlikView https://community.qlik.com/t5/QlikView/Setting-Goals/m-p/226292#M589191 <HTML><HEAD></HEAD><BODY><P>I'd like to set a goal on a chart based on a few pieces of information. How do I create a reference line on a chart to express a goal in dollars where:</P><P>1. A ship date is not null</P><P>2. and the product is of a particular type</P><P>2. then multiply the total units shipped by a given dollar value per unit .</P><P>If ShipDate Not Null and ProductType=Bike, then multiply the total Bikes by $100.</P><P>Thanks.</P></BODY></HTML> Thu, 28 Jan 2010 22:49:58 GMT 2010-01-28T22:49:58Z Setting Goals https://community.qlik.com/t5/QlikView/Setting-Goals/m-p/226292#M589191 <HTML><HEAD></HEAD><BODY><P>I'd like to set a goal on a chart based on a few pieces of information. How do I create a reference line on a chart to express a goal in dollars where:</P><P>1. A ship date is not null</P><P>2. and the product is of a particular type</P><P>2. then multiply the total units shipped by a given dollar value per unit .</P><P>If ShipDate Not Null and ProductType=Bike, then multiply the total Bikes by $100.</P><P>Thanks.</P></BODY></HTML> Thu, 28 Jan 2010 22:49:58 GMT https://community.qlik.com/t5/QlikView/Setting-Goals/m-p/226292#M589191 2010-01-28T22:49:58Z