topic Re: Modify my chart 2 expression to SET in QlikView

Modify my chart 2 expression to SET

paulyeo11 — Sat, 30 Jan 2016 20:16:57 GMT

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

Re: Modify my chart 2 expression to SET

MK_QSL — Sat, 30 Jan 2016 20:35:50 GMT

Use 2nd Expression as below

Sum(

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

Amount*-1)

Re: Modify my chart 2 expression to SET

MK_QSL — Sun, 31 Jan 2016 11:06:10 GMT

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

and

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

Re: Modify my chart 2 expression to SET

paulyeo11 — Sun, 31 Jan 2016 11:20:23 GMT

Hi Manish

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

Paul

Re: Modify my chart 2 expression to SET

MK_QSL — Sun, 31 Jan 2016 11:21:57 GMT

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)

Re: Modify my chart 2 expression to SET

paulyeo11 — Sun, 31 Jan 2016 11:28:55 GMT

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

Re: Modify my chart 2 expression to SET

MK_QSL — Sun, 31 Jan 2016 11:46:13 GMT

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

and

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

Re: Modify my chart 2 expression to SET

paulyeo11 — Sun, 31 Jan 2016 11:50:32 GMT

Hi Manish

Thank you very much. it work fine now.

Paul

Re: Modify my chart 2 expression to SET

paulyeo11 — Sun, 31 Jan 2016 12:18:36 GMT

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