Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Share your agentic AI experience, learn from others, and earn a new badge: Put Agentic AI to Work
cancel
Showing results for 
Search instead for 
Did you mean: 
meg007
Contributor
Contributor

Fixed group by in qlik sense

How can I replicate this formula in qlik sense

{​​​​ FIXED [Supplier Name]:IF ([# Invoices]-([Max Invoices per Month]*COUNTD([Month-Year])))<0
    THEN 0
    ELSE [# Invoices]-([Max Invoices per Month]*COUNTD([Month-Year]))
END}​​​​

0 Replies