topic some questions in QlikView https://community.qlik.com/t5/QlikView/some-questions/m-p/257500#M97311 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Mon, 06 Feb 2012 17:31:17 GMT 2012-02-06T17:31:17Z some questions https://community.qlik.com/t5/QlikView/some-questions/m-p/257498#M97309 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>First, I would like to make a first tab showing just the status of some KPI's. When I try to make my expression (a simple average) relative to show a gauge based on one of the values of a dimension I cannot. Is there a way around this? which function might do this. ( I used so far: IF(KPI_ID='KPI1', Avg (Percentage)) but then he states their are no values to be shown.)</P><P></P><P>thanks,</P><P></P><P>k</P></BODY></HTML> Mon, 06 Feb 2012 17:03:28 GMT https://community.qlik.com/t5/QlikView/some-questions/m-p/257498#M97309 2012-02-06T17:03:28Z some questions https://community.qlik.com/t5/QlikView/some-questions/m-p/257499#M97310 <HTML><HEAD></HEAD><BODY><P>Not sure if this is your problem, but try to put your if() inside your aggregation:</P><P></P><P>= Avg( if( KPI_ID='KPI11', Percentage))</P><P></P><P>or using set expression</P><P>= Avg( {&lt;KPI_ID = {KPI11}&gt;} Percentage)</P></BODY></HTML> Mon, 06 Feb 2012 17:12:11 GMT https://community.qlik.com/t5/QlikView/some-questions/m-p/257499#M97310 swuehl 2012-02-06T17:12:11Z some questions https://community.qlik.com/t5/QlikView/some-questions/m-p/257500#M97311 <HTML><HEAD></HEAD><BODY><P>thanks a lot</P></BODY></HTML> Mon, 06 Feb 2012 17:31:17 GMT https://community.qlik.com/t5/QlikView/some-questions/m-p/257500#M97311 2012-02-06T17:31:17Z