Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a Stack Chart Below with three Dimensions
1) (vValueListL1) which is ValueList('Case Reserves')
2) ValueList('Actual','Expected') as Fake Dimension to give me 2 Bars
3) Quarters (Like Q1,Q2,Q3 and Q4) (they are Cumulative
. Expression is
If($(vValueListL1)='Case Reserves',
(Pick(Match(ValueList('Actual','Expected'),'Actual','Expected'),
Num(Sum({<NEW_YTD_FLAG={'1'}>}(OUTST_INDEMNITY_RESERVE_YTD+OUTST_EXPENSE_RESERVE_YTD)),'#,##0'),
Num(Sum({<NEW_YTD_FLAG={'1'}>}(OUTST_INDEMNITY_RESERVE_YTD+OUTST_EXPENSE_RESERVE_YTD)*0.5),'#,##0'))))
After I do all that I get the Attached Output , which is not what I want,
I Expect the Quarters to Stack up on Each Bar.
Pls Help
Hi,
I tried with a similar example and I don' t have any problem (image attached).
Is dimension Quarter linked to your fact table?
Elena
ITs just one table, and I am calculating the Quarters using Month, in the script
If(Month<='3','Q1',If(Month >'3' and Month <= '6','Q2',
If(Month >'6' and Month <= '9','Q3','Q4'))) as Quarters
. Can you please attach your QVW?
ITs just one table, and I am calculating the Quarters using Month, in the script
If(Month<='3','Q1',If(Month >'3' and Month <= '6','Q2',
If(Month >'6' and Month <= '9','Q3','Q4'))) as Quarters
. Can you please attach your QVW?
Hi,
sorry for my delay.
Here is the qvw.
Elena