How do I implement HAVING from SQL in my Qlikview script?

[cliff_clayman]

I have some code I am trying to change over from SQL to Qlikview and there is one part I am struggling with.  Here is my script so far:

E1P_Count:
LOAD [Purchasing Document Number],[Item],[Assignment],
Count([Purchasing Document Number]&[Item]) as SingleAssignment,
If(Count([Purchasing Document Number]&[Item]) = 1,'SingleAssignmentFlag',
If(Count([Purchasing Document Number]&[Item]) > 1,'QtyDiffFlag')) as Flag

Resident E1P
GROUP BY [Purchasing Document Number],[Item],[Assignment],[Company Code];

I am using a HAVING clause in my SQL script...

HAVING
Count(SingleAssignment) > 1

How can I implement this into my Qlikview script?

[VishalWaghole]

Hi,

Please refer below post,

https://community.qlik.com/t5/QlikView-App-Development/having-clause-in-Qlikview/td-p/159301

Thanks,
Vishal

[cliff_clayman]

That doesn't work for me. It gives me an Unknown Error. Can someone please show me where in my script to implement this?