topic Invalid expression in QlikView https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/461482#M172316 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Im trying to make this expression</P><P></P><P>Load</P><P>[journalnr],</P><P>(date - regdate)/(count(items)) as average</P><P></P><P>when i reload I get invalid expression</P><P></P><P>date - regdate gives me the number of days</P><P>count items is the number af items</P><P>so what I want is number of days divided by number of items</P><P></P><P>sorry I cant attach file</P><P></P><P></P><P>thanx</P></BODY></HTML> Wed, 17 Apr 2013 08:34:22 GMT 2013-04-17T08:34:22Z Invalid expression https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/461482#M172316 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Im trying to make this expression</P><P></P><P>Load</P><P>[journalnr],</P><P>(date - regdate)/(count(items)) as average</P><P></P><P>when i reload I get invalid expression</P><P></P><P>date - regdate gives me the number of days</P><P>count items is the number af items</P><P>so what I want is number of days divided by number of items</P><P></P><P>sorry I cant attach file</P><P></P><P></P><P>thanx</P></BODY></HTML> Wed, 17 Apr 2013 08:34:22 GMT https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/461482#M172316 2013-04-17T08:34:22Z Re: Invalid expression https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/461483#M172317 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>you cannot do a count() inside the script as the script take the rows one by one.</P><P>The only way to achieve what you want to do is to create a temp table with a 'group by' to calculate that count before using the information.Hope I am clear enough.</P><P></P><P>Philippe</P></BODY></HTML> Wed, 17 Apr 2013 12:34:34 GMT https://community.qlik.com/t5/QlikView/Invalid-expression/m-p/461483#M172317 PhilippeMotillon 2013-04-17T12:34:34Z