topic sum only first month selected in QlikView

sum only first month selected

Thu, 12 Jan 2012 14:17:50 GMT

Hi All,

I'm trying to do a sum with a chart, but can't seem to find the right solution

I want to set the Month to something like Month = first selected Month.

Did try the following, but somehow the month is not selected correctly.

Sum(If(MES=MIN(MES),QTYAVAILUM))

Anyone got suggestions??

thx

Marcela

sum only first month selected

swuehl — Thu, 12 Jan 2012 14:33:16 GMT

Where do you want to use this expression? What are your dimensions? Is MES field of numerical type?

You could give this a try:

= sum({<MES = {$(=min(MES))}>} QTYAVAILUM)

Regards,

Stefan

sum only first month selected

Thu, 12 Jan 2012 14:40:32 GMT

Thanks swuehl,

That works!!!!

sum only first month selected

swuehl — Thu, 12 Jan 2012 14:47:35 GMT

I think the problem in your original expression is that you are using an aggregation function (min) within an aggregation function (sum), which will not work. You should get an error in expression dialog, right?

You could use a dollar sign expansion like

Sum(If(MES=$(=MIN(MES)),QTYAVAILUM))

to overcome this, here, I believe Min(MES) will be evaluated in global context (also in the set expression above).

sum only first month selected

Thu, 12 Jan 2012 17:33:32 GMT

You're right, i'm new in this...

That works too, thnks!