Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
cliff_clayman
Creator II
Creator II

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

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?

Labels (3)
2 Replies
VishalWaghole
Specialist II
Specialist II

cliff_clayman
Creator II
Creator II
Author

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