Qlik Community

Qlik Sense App Development

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

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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

Re: Qliksense Calculation

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

Highlighted
Contributor
Contributor

Re: Qliksense Calculation

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