Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

How do I get a Sum if to work using the Total Function

Hi there,

I need to put in a KPI that is working out the % of a total amount of Customers but I need to use a sum if to select a fixed variable.

The formula I have so far is as follows:

sum(if([No. of Insertions]=1,(Customers)))/sum(if([No. of Insertions]=1,(Total Customers)))

I am getting the error of : ')' Expected, but no matter where I try and put brackets, it doesn't seem to like the 'Total' being in there

Can anyone help?

Thank you

1 Reply

Re: How do I get a Sum if to work using the Total Function

Try this

Sum({<[No. of Insertions] = {1}>} Customers)/Sum(TOTAL {<[No. of Insertions] = {1}>} Customers)