Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

having clause in Qlikview

Hi,

Is there any function similar to Having Clause of Sql Statement.

11 Replies
Not applicable
Author

Hello

Can you help me to adapt this SQL for QlikView?

  SELECT FULLNAME_RAW_SOURCE || '  ' || BIRTHDATE AS FIO_DR, COUNT (*)

    FROM tab1

GROUP BY FULLNAME_RAW_SOURCE || '  ' || BIRTHDATE

  HAVING COUNT (FULLNAME_RAW_SOURCE || '  ' || BIRTHDATE) > 1

I need a unique record "name + date of birth" in the case, if it more than one in the source table (tab1).

Not applicable
Author

Hello, try this article

HAVING Clause In QlikView