Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor
Contributor

Qliksense Calculation

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 );

2 Replies
Highlighted
MVP
MVP

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

Highlighted
Contributor
Contributor

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