topic Set Analysis in QlikView

Set Analysis

Tue, 18 Oct 2011 10:55:33 GMT

sum({<Year={$(=Max(Year)-1)},MonthNo={"<=$(=Max({<Year={$(=Max(Year))}>}MonthNo))"}>}IF(ISNULL(GI_Weight)=-1,0,GI_Weight))

I am using this expresion to get previous year figure.

Bt it is taken max(MonthNo) which is 8 for all company.

Max(MonthNo) is different for different comapny in current yr.

Figure are showing upto Aug from Jan. Bt i want to show comapny wise max(MonthNo).

How can i do this.

rohit214 — Tue, 18 Oct 2011 11:20:49 GMT

try this

sum({<Year={$(=Max(Year)-1)},MonthNo={"<=$(=Max(}MonthNo))"}>}IF(ISNULL(GI_Weight)=-1,0,GI_Weight))

may it helps you

thanks

rohit

lironbaram — Tue, 18 Oct 2011 11:23:03 GMT

hei

you need to replace your set analysis part of the month to if statment

you need to understand that set analysis is making the selection outside the chart that means

it look on all companies when calculating the max MonthNo

Tue, 18 Oct 2011 12:57:32 GMT

This not working.......

pls give me a sugestion.

Tue, 18 Oct 2011 13:00:25 GMT

I am attaching one qvw file and one excell file.

It will help to understand my problem.

Please give me a solution.

Thanks in advamce.