Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
meg007
Contributor
Contributor

Replicating Tableau Fixed in qlik sense

I want to replicate the following formula in Tableau to 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