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

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

paulyeo11 — Thu, 18 Feb 2016 01:04:23 GMT

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

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

paulyeo11 — Thu, 18 Feb 2016 01:06:30 GMT

Enclosed my Sample QV Doc

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

jagan — Thu, 18 Feb 2016 01:37:52 GMT

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))

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

paulyeo11 — Thu, 18 Feb 2016 01:48:41 GMT

Hi Jagan

Cannot work.

Paul

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

jagan — Thu, 18 Feb 2016 02:03:07 GMT

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 ?

sunny_talwar — Thu, 18 Feb 2016 02:39:30 GMT

May be this:

Money(

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

, $(vMoneyFormatK))

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

paulyeo11 — Thu, 18 Feb 2016 03:20:20 GMT

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 ?

sunny_talwar — Thu, 18 Feb 2016 03:23:28 GMT

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

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

paulyeo11 — Thu, 18 Feb 2016 04:06:18 GMT

Done