How to add set expression with add (RangeSum(Above ?

[paulyeo11]

Hi Sunny

I have one more expression need to add above(range ,

money(

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

, $(vMoneyFormatK))

I have try below exrepssion but it does not work :-

Money

(RangeSum(Above

(TOTAL Sum(DISTINCT

{$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)

, 0, RowNo(TOTAL)

))

, $(vMoneyFormatK))

Paul

[paulyeo11]

Enclosed my Sample QV Doc

[jagan]

Hi,

Try this expression

money(

RangeSum(Above(TOTAL sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000)),

sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000))

, $(vMoneyFormatK))

[paulyeo11]

Hi Jagan

Cannot work.

Paul

[jagan]

Try this

money(

RangeSum(Above(TOTAL sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000), 0, RowNo(TOTAL)))

, $(vMoneyFormatK))

Regards,

Jagan.

[sunny_talwar · Accepted solution]

May be this:

Money(

RangeSum(Above(sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000), 0, RowNo()))

, $(vMoneyFormatK))

[paulyeo11]

Hi All

Thank you very much both sunny and Jagan , it work fine now.

Paul

[sunny_talwar]

If Jagan responses were helpful, please mark them as helpful Paul (Qlik Community Tip: Marking Replies as Correct or Helpful)

[paulyeo11]

Done