Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this:
Money(
RangeSum(Above(sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000), 0, RowNo()))
, $(vMoneyFormatK))
Enclosed my Sample QV Doc
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))
Hi Jagan
Cannot work.
Paul
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.
May be this:
Money(
RangeSum(Above(sum({$<year = {$(=max(year)-1)}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}$(ColumnDim51)/$(Columndim89)/1000), 0, RowNo()))
, $(vMoneyFormatK))
Hi All
Thank you very much both sunny and Jagan , it work fine now.
Paul
If Jagan responses were helpful, please mark them as helpful Paul (Qlik Community Tip: Marking Replies as Correct or Helpful)
Done