# 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

## 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
MVP

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

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

6 Replies
Valued Contributor II

My QV sample Doc

MVP

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

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

Valued Contributor II

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

Hi Sunny

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

Paul

MVP

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

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

Valued Contributor II

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

Hi sunny

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

MVP

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

Yes I am working as a QlikView Developer