9 Replies Latest reply: Jul 28, 2015 2:52 PM by Sasidhar Parupudi RSS

    alternative to 'where count()>1'?

      Hi Everybody,

      I have experience using sql.

      In sql you can run:




      from 'x/filepath'

      where count(salary)>1;


      if there were two employeees named 'Matt Smith' then the resulting data would be

      Matt Smith          50k
      Matt Smith          47k

      is there an equivalent of this in qlikview?

      When I put 'where count(salary)>1', it says my execution failed.


      Thanks for any help