Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi Andy
Kindly send the file again , as after i download i get below error.
opens fine for me.
Perhaps rename it.
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
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