topic threshold in QlikView https://community.qlik.com/t5/QlikView/threshold/m-p/472277#M176366 <HTML><HEAD></HEAD><BODY><P>I want to calculate threshold on multiple different parameters. ie year, month, day, hours etc for certain catagory.</P><P></P><P></P><P>1) what is the best way to show all these analysis in same chart, can it be done or should I use seperate charts for each catagory.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; should i use guage chart, bar chart, line chart. give your ideas and point to example if there are any.</P><P></P><P>2) Whats the formula to calculate.&nbsp; Average total sales (as per user selection of either year, month, day, hours) *120%&nbsp; and use it as threshold ot mark high performers.</P></BODY></HTML> Thu, 13 Jun 2013 19:48:34 GMT userid128223 2013-06-13T19:48:34Z threshold https://community.qlik.com/t5/QlikView/threshold/m-p/472277#M176366 <HTML><HEAD></HEAD><BODY><P>I want to calculate threshold on multiple different parameters. ie year, month, day, hours etc for certain catagory.</P><P></P><P></P><P>1) what is the best way to show all these analysis in same chart, can it be done or should I use seperate charts for each catagory.</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; should i use guage chart, bar chart, line chart. give your ideas and point to example if there are any.</P><P></P><P>2) Whats the formula to calculate.&nbsp; Average total sales (as per user selection of either year, month, day, hours) *120%&nbsp; and use it as threshold ot mark high performers.</P></BODY></HTML> Thu, 13 Jun 2013 19:48:34 GMT https://community.qlik.com/t5/QlikView/threshold/m-p/472277#M176366 userid128223 2013-06-13T19:48:34Z