Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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