Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I have expression as below work fine for chart 1:-
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} $(ColumnDim51)/1000/$(Columndim89))
I also have expression below work fine for chart 2 :-
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} $(ColumnDim601)/1000/$(Columndim89))
when user select Dim2 = rEVENUE , I have convert the above expression to below , and this expression i insert at Chart 3 :-
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} rEVENUE={rEVENUE}>}Amount/1000/$(Columndim89))
Chart 3 Dimension expression as below :-
=if(aggr(sum(sales),$(ColumnDim101)) / aggr(sum(total <$(ColumnDim_p)> sales), $(ColumnDim101)) > 0.00001, $(ColumnDim101), ' Other')
Can some one advise me how to change the above expression sales to rEVENUE ?
So that chart 3 is able to display the bar.
Paul
Hi Paul,
I was checking your expression, please check the characters in bold and red:
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} rEVENUE={rEVENUE}>}Amount/1000/$(Columndim89))
I just remove those characters (I also added single quotes to your rEVENUE value):
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, rEVENUE={'rEVENUE'}>}Amount/1000/$(Columndim89))
The chart displays the following information, but I'm not sure if this fills your needs:
Regards,
-- Karla
My QV Doc
Hi Paul,
I was checking your expression, please check the characters in bold and red:
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} rEVENUE={rEVENUE}>}Amount/1000/$(Columndim89))
I just remove those characters (I also added single quotes to your rEVENUE value):
sum({$<year = {"<=$(=max(year)) >=$(=max(year)-12)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, rEVENUE={'rEVENUE'}>}Amount/1000/$(Columndim89))
The chart displays the following information, but I'm not sure if this fills your needs:
Regards,
-- Karla
Hi Karla
Thank you for your advise . I have test it does give the chart. But due to my dimension expression have some issue , i need to solve it .
Paul