topic Add expression in the load script in QlikView https://community.qlik.com/t5/QlikView/Add-expression-in-the-load-script/m-p/255775#M96807 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have this expression in a list box to create an specific tyoe of filter. </P><P></P><P>=if(empty='false', Aggr(Count({&lt;blocked={0}&gt;}transaction_id), session_id))</P><P></P><P>Due to this, my qlikview document is too slow, I just want to add this expression somehow to the load script and have it as a field. I can't use aggregatoions there and empty,blocked,session_id belong to one table while transaction_id belongs to another. The tables are linked by the field session_id.</P><P></P><P>Any help would be appreciated!</P><P></P><P>thanks</P></BODY></HTML> Mon, 08 Aug 2011 10:12:44 GMT 2011-08-08T10:12:44Z Add expression in the load script https://community.qlik.com/t5/QlikView/Add-expression-in-the-load-script/m-p/255775#M96807 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have this expression in a list box to create an specific tyoe of filter. </P><P></P><P>=if(empty='false', Aggr(Count({&lt;blocked={0}&gt;}transaction_id), session_id))</P><P></P><P>Due to this, my qlikview document is too slow, I just want to add this expression somehow to the load script and have it as a field. I can't use aggregatoions there and empty,blocked,session_id belong to one table while transaction_id belongs to another. The tables are linked by the field session_id.</P><P></P><P>Any help would be appreciated!</P><P></P><P>thanks</P></BODY></HTML> Mon, 08 Aug 2011 10:12:44 GMT https://community.qlik.com/t5/QlikView/Add-expression-in-the-load-script/m-p/255775#M96807 2011-08-08T10:12:44Z