topic Re: Sum in SetAnalisys in QlikView

Sum in SetAnalisys

Marcoimp — Wed, 09 Oct 2013 16:22:32 GMT

How can I get the count of clients of this year that the last year bought more than 2500€ of pieces?

I found this formula:

=count({$<

YEAR={2013},

CONTACTID = {"=Sum({$<YEAR = {2012}>} VALSALES ) >= 2500"}

>} CONTACTID)

But it doesn't work!

Where I'm wrong?

Thank you.

swuehl — Wed, 09 Oct 2013 16:25:34 GMT

It looks quite ok to me. I would probably do a DISTINCT count, though.

What do you mean with 'doesn't work'? No result? Wrong result?

Have you double checked all field names, that they are correctly spelled?

Marcoimp — Wed, 09 Oct 2013 16:34:44 GMT

I find, my error. There's a fieldname with a "S" more (VALSALE not VALSALES).

It's strange it gives Zero, anyway......

Thank you.