Modify my chart 2 expression to SET

[paulyeo11]

Hi All

Both chart 1 & 2 work fine on 2015.  They are both able to display Expense trend , TOTAL_EXP field from sales table and eXP field name from GL Table.

For chart 1 still working fine when i click on year = 2014. But Chart 2 no work any more.

My question is for chart 2 field name = {<eXP={"eXP"}, how to make it still able to display Exp line when user change to year = 2014 ?

My assume SET expression is using Chart 1 expression below  :-

money(

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} TOTAL_EXP/1)/1

, $(vMoneyFormatK))

Modify the field name below :-

money(

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} {<eXP={"eXP"}/1)/1

, $(vMoneyFormatK))

But it does not work.

I will post my sample QC Doc in my next posting.

Paul

[MK_QSL]

Use 2nd Expression as below

Sum(

{<Year={'>$(=Max(year)-2)'}, eXP={"eXP"}>}

Amount*-1)

[MK_QSL]

Sum({<year={'=$(Max(year))'}, eXP={"eXP"}>}Amount*-1)

and

Sum({<year={'=$(Max(year)-1)'}, eXP={"eXP"}>}Amount*-1)

[paulyeo11]

Hi Manish

I just try your expression , it does not work , may be missing one {.

Paul

[MK_QSL]

check Year and year... you have two fields... Year and year... use lower case one..

SUM({<year = {"$(=Max(year))"}>}Amount)

SUM({<year = {"$(=Max(year)-1)"}>}Amount)

[paulyeo11]

Hi Manish

May i know , below field name need to insert where ?

eXP={"eXP"}

I mean above field name insert to expression below where :-

SUM({<year = {"$(=Max(year))"}>}Amount)

Paul

[MK_QSL · Accepted solution]

SUM({<year = {"$(=Max(year)-1)"},eXP={"eXP"}>}Amount)

and

SUM({<year = {"$(=Max(year))"},eXP={"eXP"}>}Amount)

[paulyeo11]

Hi Manish

Thank you very much. it work fine now.

Paul

[paulyeo11]

Hi Sir

Below expression when click on month= 6 ( the line chart only display one dot ), it will display only june amount. i need it display jan till june line.

SUM({<year = {"$(=Max(year))"},rEVENUE={"rEVENUE"}>}Amount*1)/1000

in order to modify the above expression , to display jan till june line chart , i assume the expression should be below :-

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} ,rEVENUE={"rEVENUE"}>}Amount*1)

But it never work.

Paul