topic Re: SET ANALYSIS ISSUE in QlikView

SET ANALYSIS ISSUE

Wed, 19 Feb 2014 17:16:35 GMT

Max Year works for this Expression

(Sum({<CloseAdmin_Year={$(=Max(Year))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year))}>} NET_INDEMNITY_PAID)+

Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max(CloseAdmin_Year)'},Month = {

"<=$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/(Count({<CloseAdmin_Year={$(=Max(Year))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year))}>} distinct

[Claim No])+

Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max(CloseAdmin_Year)'},Month = {"<=$(=Max(Month))"}>} DISTINCT [Occurence No]))

But not working for MAx(Year)-1,

=(Sum({<CloseAdmin_Year={$(=Max(Year)-1)},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year)-1)}>} NET_INDEMNITY_PAID)+

Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max((CloseAdmin_Year)-1)'},Month = {

"<=$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/
(Count({<CloseAdmin_Year={$(=Max(Year)-1)},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=Max(Year)-1)}>} distinct [Claim No])+

Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=Max((CloseAdmin_Year)-1)'},Month = {"<=$(=Max(Month))"}>} DISTINCT [Occurence No]))

Any Clues

Re: SET ANALYSIS ISSUE

fernando_tonial — Wed, 19 Feb 2014 17:29:00 GMT

Add a more brackets.

See underscore.

=(Sum({<CloseAdmin_Year={$(=(Max(Year)-1))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=(Max(Year)-1))}>} NET_INDEMNITY_PAID)+

Sum({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=(Max((CloseAdmin_Year)-1))'},Month = {

"<=$(=Max(Month))"}>} NET_INDEMNITY_PAID))
/
(Count({<CloseAdmin_Year={$(=(Max(Year)-1))},NET_INDEMNITY_PAID={"<1000000>0"},Occurence_Number_Flag={'0'},Year={$(=(Max(Year)-1))}>} distinct [Claim No])+

Count({<[Occurence No]={'=sum(NET_INDEMNITY_PAID)>0 and sum(NET_INDEMNITY_PAID)<1000000 and Year=(Max((CloseAdmin_Year)-1))'},Month = {"<=$(=Max(Month))"}>} DISTINCT [Occurence No]))

Best Regards.

Tonial.

Re: SET ANALYSIS ISSUE

Wed, 19 Feb 2014 17:46:07 GMT

Doesnt Work, any more ideas pls

Re: SET ANALYSIS ISSUE

Colin-Albert — Wed, 19 Feb 2014 17:48:05 GMT

Have you tried Max(Year -1)

Re: SET ANALYSIS ISSUE

Wed, 19 Feb 2014 17:54:15 GMT

Yes I did

Re: SET ANALYSIS ISSUE

santharubban — Wed, 19 Feb 2014 17:56:35 GMT

can u try this add '$(=(Max(Year)-1))'

Sum({<CloseAdmin_Year={'$(=(Max(Year)-1))'},

Re: SET ANALYSIS ISSUE

Nicole-Smith — Wed, 19 Feb 2014 17:59:07 GMT

If Year is a dimension on your chart, it's not going to work.

Re: SET ANALYSIS ISSUE

Wed, 19 Feb 2014 18:00:25 GMT

No Dimenion is the Month