# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Rules, plus terms and conditions, can be found here.
Valued Contributor II

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
MVP

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

Enclosed my Sample QV Doc

MVP

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

Valued Contributor II

Hi Jagan

Cannot work.

Paul

MVP

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.

MVP

May be this:

Money(

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

, \$(vMoneyFormatK))

Valued Contributor II

Hi All

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

Paul

MVP