Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
paulyeo11
Valued Contributor II

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

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

1 Solution

Accepted Solutions

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

May be this:

Money(

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

, $(vMoneyFormatK))

8 Replies
paulyeo11
Valued Contributor II

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

Enclosed my Sample QV Doc

MVP
MVP

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

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
Valued Contributor II

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

Hi Jagan

Cannot work.

Paul

MVP
MVP

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

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.

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

May be this:

Money(

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

, $(vMoneyFormatK))

paulyeo11
Valued Contributor II

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

Hi All

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

Paul

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

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

paulyeo11
Valued Contributor II

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

Done

Community Browser