topic Re: Qliksense Calculation in App Development https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53238#M3548 <HTML><HEAD></HEAD><BODY><P>I'm trying to achieve it with expression in a chart object.</P></BODY></HTML> Thu, 21 Jun 2018 06:26:33 GMT Anonymous 2018-06-21T06:26:33Z Qliksense Calculation https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53236#M3546 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Hello all,</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">I'm new to qliksense and i couldn't perform below SQL query via calculations. Could you please help me ? Thanks in advance.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; SELECT&nbsp; count(HOSTNAME) as COUNT</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM TABLE</SPAN></P><P><SPAN style="font-size: 13.3333px;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where INSERTTIME = (select max(INSERTTIME) FROM TABLE );</SPAN></P></BODY></HTML> Wed, 20 Jun 2018 07:09:33 GMT https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53236#M3546 Anonymous 2018-06-20T07:09:33Z Re: Qliksense Calculation https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53237#M3547 <HTML><HEAD></HEAD><BODY><P>Are you trying to do that in the load script or as an expression in a chart object in a sheet?</P></BODY></HTML> Wed, 20 Jun 2018 15:34:49 GMT https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53237#M3547 petter 2018-06-20T15:34:49Z Re: Qliksense Calculation https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53238#M3548 <HTML><HEAD></HEAD><BODY><P>I'm trying to achieve it with expression in a chart object.</P></BODY></HTML> Thu, 21 Jun 2018 06:26:33 GMT https://community.qlik.com/t5/App-Development/Qliksense-Calculation/m-p/53238#M3548 Anonymous 2018-06-21T06:26:33Z