Qliksense Calculation

[Anonymous]

Hello all,

I'm new to qliksense and i couldn't perform below SQL query via calculations. Could you please help me ? Thanks in advance.

      SELECT  count(HOSTNAME) as COUNT

      FROM TABLE

      where INSERTTIME = (select max(INSERTTIME) FROM TABLE );

[petter]

Are you trying to do that in the load script or as an expression in a chart object in a sheet?

[Anonymous]

I'm trying to achieve it with expression in a chart object.