topic Re: How do I implement HAVING from SQL in my Qlikview script? in QlikView

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

cliff_clayman — Sat, 16 Nov 2024 21:05:08 GMT

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?

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

VishalWaghole — Tue, 09 Apr 2019 17:42:58 GMT

Hi,

Please refer below post,

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

Thanks,
Vishal

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

cliff_clayman — Tue, 09 Apr 2019 18:41:32 GMT

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