Sumifs function in qlikview

[jyothish8807]

Hi,

How to create a sumifs (Excel function) function in QV?

Regards

KC

[jyothish8807]

Hi tresesco,

In your app when i take a,b.c iam getting all values of A (1,2,1,3)

But when i make the same chart iam getting only A (1,1,3) Iam not getting the entries of 2.Why is it so? Whatds the trick?

Regards

KC

[tresesco]

If you want the missing one, try:

If(A=Aggr(NODISTINCT B,B),Sum( total <B>C),0)

and then in presentation tab uncheck 'Supress Zero-Values'.

[jyothish8807]

Got it.Thaks a lot.Its working with the previous expression also.It was supress Zero issue.

Regards

KC