Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

why currency sign can display on table 2 but not display on Table 1 with sales by month?

Hi All

This happen only when i display amount by month.

I am unable to figure out where go wrong ?

Hope some one can advise me.

Paul

1 Solution

Accepted Solutions
sunny_talwar

Try this expression instead of using Full Accumulation:

Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))


Capture.PNG

View solution in original post

6 Replies
paulyeo11
Master
Master
Author

My QV sample Doc

sunny_talwar

Try this expression instead of using Full Accumulation:

Money(RangeSum(Above(TOTAL Sum(DISTINCT{<year = {"$(=Max(year)-0)"},$(ColumnDim51) ={$(ColumnDim51)}>} Amount*1/ $(Columndim89)/1000), 0, RowNo(TOTAL))), $(vMoneyFormatK))


Capture.PNG

paulyeo11
Master
Master
Author

Hi Sunny

wow , you are good. By the way Can you explain to me why RangeSum(Above will do the trick ?

Paul

sunny_talwar

It seems that the inbuilt accumulation removes the formatting from the expression, but with RangeSum(Above()) we are able to keep the formatting intact.

paulyeo11
Master
Master
Author

Hi sunny

Thank you for your explanation.

By the way are your job very focus on QV development ? Because I just wonder why you know so much ?

Paul

Sent from my iPhone

sunny_talwar

Yes I am working as a QlikView Developer