Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)))
Look here to see how to share a sample