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

    alternative to 'where count()>1'?

    Gabe M

      Hi Everybody,

      I have experience using sql.

      In sql you can run:

       

      select
      name,

      salary

      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