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 ISSUE

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

7 Replies
fernando_tonial
Partner - Specialist
Partner - Specialist

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.

Don't Worry, be Qlik.
Not applicable
Author

Doesnt Work, any more ideas pls

Colin-Albert

Have you tried      Max(Year -1)

Not applicable
Author

Yes I did

santharubban
Creator III
Creator III

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

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

Nicole-Smith

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

Not applicable
Author

No Dimenion is the Month