topic Re: QS How to combine 2 Revenue and Net Profit Table into 1 Table ? in App Development

QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

paulyeo11 — Sat, 05 Sep 2015 15:03:10 GMT

Hi All

I have learn last few day on below, on how to make 1 chart display sales , cost , profit_amount :-

when i have expression = sum(sales) , using Pick(Match

Sum($(Var))

So the Diamension is below :-

Pick(Match($(Var),1,2,3),sales,cost,profit_amount)

Above are working fine.

Now I wish to apply above for combine Table 1 Reveune and Table 2 Net Profit into One Table which display Revenue and Net Profit.

Now i have new expression , which is more complicated , to replace with Pick ( Match :-

Sum({<rEVENUE={"rEVENUE"}>}Amount)/1000

Sum({<nET_PROFIT={"nET_PROFIT"}>}Amount)/1000

I try below :-

Pick(Match($(Var),1,2,3,4),rEVENUE,nET_PROFIT)

But it does not work.

Enclsoed my QVF.

Paul

Re: QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

ogster1974 — Mon, 07 Sep 2015 15:14:54 GMT

See attached fix for your issue. You had 2 many options I think in your match. You have 4 where you only had 2 choices

I've added a dynamic title to your table and made your measure title more generic as you cannot alter it in an expression.

Hope this helps,

Regards

Andy

Re: QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

paulyeo11 — Mon, 07 Sep 2015 23:16:01 GMT

Hi Andy

Kindly send the file again , as after i download i get below error.

Re: QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

ogster1974 — Tue, 08 Sep 2015 07:49:47 GMT

opens fine for me.

Perhaps rename it.

Re: QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

paulyeo11 — Tue, 08 Sep 2015 09:11:56 GMT

Hi Andy

I try to download , i notice that it stop download at 1.1 Mb. when i open i get error again.

I ask my staff to download , and he also facing the same problem.

May be you can email paul11ipad@gmail.com

Paul

Re: QS How to combine 2 Revenue and Net Profit Table into 1 Table ?

paulyeo11 — Tue, 08 Sep 2015 09:40:30 GMT

Hi Andy

Thank you i just received your file from my gmail , and it is 3.8 mb , so i confirm when i download , due to indonesia wifi net work slow , so it stop download half way.

may be if i use limit load data , it will be better,

Thank you, now i need to apply the script for the rest of my code,

Paul