https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1587296#M456667 What kind of aggregation where you planning to use? Is presented in a way that only one value is available per row in your table or so you need to aggregate the speed using an maximum, minimum or average value? In the answer below I assume that multiple values is returned and thereby I use an average.<BR /><BR />= average({&lt;Ignition={'Off'}&gt;}Vehicle_speed)<BR /><BR />If a single value is assumed returned you can use only() in a similar way.<BR />= only({&lt;Ignition={'Off'}&gt;}Vehicle_speed)<BR /> Fri, 31 May 2019 22:45:04 GMT Vegar 2019-05-31T22:45:04Z https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1586781#M456665 <P>I have a case where I have to display the speed of a vehicle - (Vehicle_speed) under the condition that , Ignition is in "Off" position. How do I create a count function that would show this?</P> Thu, 30 May 2019 17:02:52 GMT https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1586781#M456665 vkesavan1 2019-05-30T17:02:52Z https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1587289#M456666 =if(Ignition='Off', Vehicle_speed)<BR /><BR />or you can attach a sample Fri, 31 May 2019 21:46:14 GMT https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1587289#M456666 Claudiu_Anghelescu 2019-05-31T21:46:14Z https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1587296#M456667 What kind of aggregation where you planning to use? Is presented in a way that only one value is available per row in your table or so you need to aggregate the speed using an maximum, minimum or average value? In the answer below I assume that multiple values is returned and thereby I use an average.<BR /><BR />= average({&lt;Ignition={'Off'}&gt;}Vehicle_speed)<BR /><BR />If a single value is assumed returned you can use only() in a similar way.<BR />= only({&lt;Ignition={'Off'}&gt;}Vehicle_speed)<BR /> Fri, 31 May 2019 22:45:04 GMT https://community.qlik.com/t5/QlikView/Conditional-Chart-Display/m-p/1587296#M456667 Vegar 2019-05-31T22:45:04Z