topic Set Analysis Problem in QlikView

Set Analysis Problem

Wed, 19 Oct 2011 04:16:11 GMT

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 — Wed, 19 Oct 2011 08:10:43 GMT

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

Wed, 19 Oct 2011 08:29:28 GMT

Hi,

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

Succes, Halmar

Wed, 19 Oct 2011 08:36:32 GMT

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.

Wed, 19 Oct 2011 09:23:54 GMT

Thanks a lot halmar.

Nice job you have done.