Set Analysis Problem

[#1]

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.

Thanks in advance.

Sukamal Naskar

[qliksus]

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

[#3 · Accepted solution]

Hi,

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

Succes, Halmar

[#4]

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.

Please see my excel sheet.

[#5]

Thanks a lot halmar.

Nice job you have done.