topic Re. :Re: Problem with SET ANALYSIS in QlikView

Problem with SET ANALYSIS

Fri, 24 Sep 2010 12:05:46 GMT

Hi Community,

Please i want to hear something on SET ANALYSIS.

When you write a SET ANALYSIS statement as SUM({$<Annee={'2010'}, NumCpt4={'4621'}>}MontantDebit)

What happens if the set on which to apply the aggregation SUM is empty?

Thanks for your help..

Fri, 24 Sep 2010 12:22:58 GMT

Hello

I think you must use " in stead of '

Like this:

If the calculation is empty I believe it returns a 0

regards, Jesper

magavi_framsteg — Fri, 24 Sep 2010 12:24:07 GMT

Hello Yimen.

What will happen is the exact same thing as would happen if you would have done the selections manually.

Ie.
- Select 2010 from field Annee
- Select 4621 from field NumCpt4
- Calculate SUM of MontantDebit

Fri, 24 Sep 2010 12:31:30 GMT

That's what I thought but it does not return me 0.

I don't what i will do???

Fri, 24 Sep 2010 12:35:22 GMT

In fact, in my table, there are no lines which NumCpt4 = "4621". Normally, the result should be 0. But this is not the case.
What to do to remedy it?

magavi_framsteg — Fri, 24 Sep 2010 12:53:00 GMT

What does it return you?

You can always use if-statements preceding SUM.

if (SUM({ set } ) > 0, do this if greater than zero, do that if not greater than zero)