Discussion board where members can get started with Qlik Sense.
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)
Add Group by before HAVING
View solution in original post