topic Re: Set Expression working in Table not work in chart ? in QlikView

Set Expression working in Table not work in chart ?

paulyeo11 — Sun, 14 Feb 2016 00:22:28 GMT

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

paulyeo11 — Sun, 14 Feb 2016 00:26:14 GMT

My QV Doc

sunny_talwar — Sun, 14 Feb 2016 01:27:09 GMT

May be this;

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

paulyeo11 — Sun, 14 Feb 2016 03:54:00 GMT

Hi Summy

Many thank for your help. Your expression is working fine.

But the chart still have little issue. when i try to display chart for whole year from jan till Dec. the currency sign not work when i set to Org.

Enclosed My QV Doc for your ref

Paul