topic Scatter Plot in App Development https://community.qlik.com/t5/App-Development/Scatter-Plot/m-p/1307753#M27858 <HTML><HEAD></HEAD><BODY><P><SPAN style="line-height: 1.5em; color: #575757; font-size: 10pt;">I have a table which has some columns which are “cumulative”. Here are the columns in the table:</SPAN></P><P><SPAN style="color: #575757;">Column 1: PERSON_ID</SPAN></P><P><SPAN style="color: #575757;">Column 2:&nbsp; Rowno(TOTAL)</SPAN></P><P><SPAN style="color: #575757;">Column 3: rangesum(above(TOTAL Sum(indicator_flag),0,rowno(TOTAL)))</SPAN></P><P></P><P><SPAN style="color: #575757;">Column 2 counts the number of people in the table cumulatively and Columns 3 does the same for an "indicator_flag" that is either 1 or 0 for every person.</SPAN></P><P></P><P><SPAN style="color: #575757;">As columns 2 and 3 are cumulative expressions the values for each consultant depends upon the sort order of the table. </SPAN></P><P></P><P><SPAN style="color: #575757;">I would like to plot columns 2 and 3 against each other – WITH A DEFINED SORT ORDER. It does not appear that I can do this. If I use cumulative expressions in the scatter plot object it appears to use an arbitrary sort order. Anyone know of any way around this?</SPAN></P></BODY></HTML> Fri, 14 Jul 2017 09:03:17 GMT 2017-07-14T09:03:17Z Scatter Plot https://community.qlik.com/t5/App-Development/Scatter-Plot/m-p/1307753#M27858 <HTML><HEAD></HEAD><BODY><P><SPAN style="line-height: 1.5em; color: #575757; font-size: 10pt;">I have a table which has some columns which are “cumulative”. Here are the columns in the table:</SPAN></P><P><SPAN style="color: #575757;">Column 1: PERSON_ID</SPAN></P><P><SPAN style="color: #575757;">Column 2:&nbsp; Rowno(TOTAL)</SPAN></P><P><SPAN style="color: #575757;">Column 3: rangesum(above(TOTAL Sum(indicator_flag),0,rowno(TOTAL)))</SPAN></P><P></P><P><SPAN style="color: #575757;">Column 2 counts the number of people in the table cumulatively and Columns 3 does the same for an "indicator_flag" that is either 1 or 0 for every person.</SPAN></P><P></P><P><SPAN style="color: #575757;">As columns 2 and 3 are cumulative expressions the values for each consultant depends upon the sort order of the table. </SPAN></P><P></P><P><SPAN style="color: #575757;">I would like to plot columns 2 and 3 against each other – WITH A DEFINED SORT ORDER. It does not appear that I can do this. If I use cumulative expressions in the scatter plot object it appears to use an arbitrary sort order. Anyone know of any way around this?</SPAN></P></BODY></HTML> Fri, 14 Jul 2017 09:03:17 GMT https://community.qlik.com/t5/App-Development/Scatter-Plot/m-p/1307753#M27858 2017-07-14T09:03:17Z