Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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.

Thanks in advance.

Sukamal Naskar

1 Solution

Accepted Solutions
Not applicable
Author

Hi,

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

Succes, Halmar

View solution in original post

4 Replies
qliksus
Specialist II
Specialist II

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

Not applicable
Author

Hi,

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

Succes, Halmar

Not applicable
Author

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.

Not applicable
Author

Thanks a lot halmar.

Nice job you have done.