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

[paulyeo11]

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

[ogster1974]

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

[paulyeo11]

Hi Andy

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

[ogster1974 · Accepted solution]

opens fine for me.

Perhaps rename it.

[paulyeo11]

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

[paulyeo11]

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