topic Access calculated data from chart in QlikView https://community.qlik.com/t5/QlikView/Access-calculated-data-from-chart/m-p/440523#M164193 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i've a chart (straight table) with calculated values. Now i want to use this values to draw a graph for example. </P><P></P><P>The values where calculated with this formula:</P><P></P><P>=if(State='Connected';(ConnectTime-(if(CallId0&lt;&gt;eid,FirstSortedValue(stime,CallId0),if(CallId0=eid,StartTime)))),'0')</P><P></P><P>How can i draw a graph with the average of this data?</P></BODY></HTML> Thu, 14 Mar 2013 09:42:18 GMT 2013-03-14T09:42:18Z Access calculated data from chart https://community.qlik.com/t5/QlikView/Access-calculated-data-from-chart/m-p/440523#M164193 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i've a chart (straight table) with calculated values. Now i want to use this values to draw a graph for example. </P><P></P><P>The values where calculated with this formula:</P><P></P><P>=if(State='Connected';(ConnectTime-(if(CallId0&lt;&gt;eid,FirstSortedValue(stime,CallId0),if(CallId0=eid,StartTime)))),'0')</P><P></P><P>How can i draw a graph with the average of this data?</P></BODY></HTML> Thu, 14 Mar 2013 09:42:18 GMT https://community.qlik.com/t5/QlikView/Access-calculated-data-from-chart/m-p/440523#M164193 2013-03-14T09:42:18Z