# 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

## Set Expression working in Table not work in chart ?

Hi All

Table 1 Expression below , Display Amount RM 35K is correct :-

money(

SUM({<year = {"\$(=Max(year)-0)"},month={"<=\$(=month)"},\$(ColumnDim51)={\$(ColumnDim51)}>}Amount*1)/\$(Columndim89)/1000,

\$(vMoneyFormatK))

How to make below expression from chart 1 also display RM 35K same as Table 1 ?

money(

SUM({<year = {"\$(=Max(year)-0)"},\$(ColumnDim51)={\$(ColumnDim51)}>}Amount*1/\$(Columndim89)/1000)

,\$(vMoneyFormatK))

Now it display RM 140K, Hope some one can advise me.

In my next post , i will post my QV Doc

Paul

1 Solution

Accepted Solutions
MVP

## Re: Set Expression working in Table not work in chart ?

May be this;

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

3 Replies
Valued Contributor II

My QV Doc

MVP

## Re: Set Expression working in Table not work in chart ?

May be this;

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

Valued Contributor II

Hi Summy