Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
BrianDH
Creator II
Creator II

Looking for examples of using "Having" in the script WHERE clause

Looking for examples of using "Having" in the script WHERE clause

where PROJECT_TYPE <> 'CME'
AND PROJECT_TYPE <> 'GRANT'
and having  sum(BH_AMOUNT_ACT + BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE + BH_AMOUNT_PAY + BH_AMOUNT_OTHER)
* 100 / sum(BH_AMOUNT_BUD) >= 75.00)

Labels (3)
1 Solution

Accepted Solutions
BrianDH
Creator II
Creator II
Author

Add Group by before HAVING

View solution in original post

1 Reply
BrianDH
Creator II
Creator II
Author

Add Group by before HAVING

View solution in original post