Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Set Analysis Problem

Hi,

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

Succes, Halmar

4 Replies
qliksus
Valued Contributor

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

Not applicable

Re: Set Analysis Problem

Hi,

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

Succes, Halmar

Not applicable

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.

Please see my excel sheet.

Not applicable

Set Analysis Problem

Thanks a lot halmar.

Nice job you have done.

Community Browser