Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
tim_leijen
Contributor III
Contributor III

Sumif function

Hi Guys!

Just trying to figure out the sumif equivalent in Qlikview.

From the forum I understood, it's =sum(if(.....

However I'm having some difficulties. So my aim is to get the total Net Contribution (NETCN) per account group.

I've followed all the steps on the forum, but for some reason the formula isn't working. Anyone has an idea?

=sum(if([Account Group], sum({<GL_1={NETCN},Dimension={ACT}>}Data)))

10 Replies
sunny_talwar

Look here to see how to share a sample

Uploading a Sample