topic Re: Peek function to solve for X in QlikView https://community.qlik.com/t5/QlikView/Peek-function-to-solve-for-X/m-p/509441#M690678 <HTML><HEAD></HEAD><BODY><P>I don't understand what you're trying to do. Can you explain with some sample data what you're trying to calculate? </P></BODY></HTML> Thu, 03 Oct 2013 16:49:27 GMT Gysbert_Wassenaar 2013-10-03T16:49:27Z Peek function to solve for X https://community.qlik.com/t5/QlikView/Peek-function-to-solve-for-X/m-p/509440#M690677 <HTML><HEAD></HEAD><BODY><P>Not sure if peek is the best way to do this, but what I am trying to figure out is looking at an organization, how many users does it take until there average sign in count per week is 1. </P><P></P><P>My initial thought is to sort by user and find there average, if it is not equal to 1 then move to the next line and find there average.&nbsp; My only issue is that can you use peek to say, evaluate line 1, then evaluate lines 1 and 2, then evaluate lines 1, 2 and 3 and so on until your average equals 1.</P><P></P><P>Hopefully I am making sense, is there a way to do this?</P></BODY></HTML> Thu, 03 Oct 2013 16:15:20 GMT https://community.qlik.com/t5/QlikView/Peek-function-to-solve-for-X/m-p/509440#M690677 jpapador 2013-10-03T16:15:20Z Re: Peek function to solve for X https://community.qlik.com/t5/QlikView/Peek-function-to-solve-for-X/m-p/509441#M690678 <HTML><HEAD></HEAD><BODY><P>I don't understand what you're trying to do. Can you explain with some sample data what you're trying to calculate? </P></BODY></HTML> Thu, 03 Oct 2013 16:49:27 GMT https://community.qlik.com/t5/QlikView/Peek-function-to-solve-for-X/m-p/509441#M690678 Gysbert_Wassenaar 2013-10-03T16:49:27Z