4 Replies Latest reply: Oct 19, 2011 5:23 AM by Sukamal Naskar

# Set Analysis Problem

Hi,

I am facing problem in set analysis for a expression.

I am attching one QVW file and one excel file, by which you can understand my problem.

Pls give me needfull sugestion.

• ###### Set Analysis Problem

Altering ur second expression like this will get u the result

sum({<Season={\$(=Max(Season)-1)},MonthNo={"<=\$(=Max({<Season={\$(=Max(Season))}>}MonthNo))"}>}Val)

If i have not understood ur issue please let me know

• ###### Set Analysis Problem

I want to take comapny wise maximum month number....not max(monthno) of all garden.

In 2011 Company A has max(MonthNo)=6          val=160

In 2011 Company B has max(MonthNo)=9          val=250

Here maximum MonthNo is coming 9

i want to show 2010 record like this

In 2010 Company A has max(MonthNo)=6          val=210

In 2010 Company B has max(MonthNo)=9          val=290

Here maximum MonthNo is coming 9

By default selection ..... means clear all field.

• ###### Set Analysis Problem

Thanks a lot halmar.

Nice job you have done.

• ###### Re: Set Analysis Problem

Hi,

I changed something in the script to get the right data.

Succes, Halmar