Hi All
The chart can only display LY bar and not able to display CY bar.
I have create a chart 2 :-
I add dimension :-
=valuelist('LY','CY')
I also add measure ( But below expression work in my other QVF ) :-
pick(wildmatch(valuelist('LY','CY'),'LY','CY'),
(
(
SUM({<year = {'$(=Max(year)-1)'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales)
)
)
,
(
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year)-0)}, sales = {'*'}>} month))"}>}sales)
)
)
I have manually test the below expression using text box display the result at QVW , it work fine :-
=num(
Sum({$<year = {$(=Max(year)-0)}, month = {"<=$(=Max({<year={$(=Max(year)-0)}, sales = {'*'}>} month))"}>}sales)
)
=num(SUM({<year = {'$(=Max(year)-1)'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales)
)
Hope some one can share with me how to troubleshoot where go wrong ?
Paul