topic Set analysis < max(YearMonth) in QlikView

Set analysis < max(YearMonth)

Fri, 07 Oct 2011 12:27:23 GMT

Hi,

Question about set analsis.

I wonder if it's possible to select every sales record smaller then the max selected year and month but keep the possibility to make selections in the dimension (the dimension contains projectnumbers).

For example, when I have the years 2010 and 2011 and months may and june selected it should sum all sales <= 201106 .

Using:

sum(

{1<

YearMonth={$(=max(YearMonth))}

Sales)

Will get the desired result but I will lose the flexibility to select any projects.

Using an aggr isn't working either:

sum(aggr(

sum(

{1<

YearMonth={$(=max(YearMonth))}

Sales)

,Project)

It give strange results. Anyone know how to fix this problem? An example is attached.

Set analysis < max(YearMonth)

Fri, 07 Oct 2011 12:44:07 GMT

Hi,

if u try this?

=sum( {<YearMonth = {"<=$(#=max(YearMonth))"}>} sales)

C u,

Stefano.

Set analysis < max(YearMonth)

Fri, 07 Oct 2011 12:51:35 GMT

And this:

sum( {$<YearMonth = {"<=$(#=max(YearMonth))"},Year,Month,Quarter>} sales)

if you don't want that year,month,quarter interfree.

Stefano

Set analysis < max(YearMonth)

Fri, 07 Oct 2011 13:12:47 GMT

Thanks Stefano. Works great 🙂 . If I understand correct the # sign returns the selection in relation to the current selection?

Set analysis < max(YearMonth)

Fri, 07 Oct 2011 13:25:10 GMT

Hi,

maybe it works without # also.

$ returns the selection in relation to the current selection