topic STACK BAR CHART ISSUE in QlikView

STACK BAR CHART ISSUE

Fri, 24 Jul 2015 14:22:55 GMT

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

Anonymous — Sun, 26 Jul 2015 08:40:26 GMT

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

Sun, 26 Jul 2015 16:31:10 GMT

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?

Sun, 26 Jul 2015 16:31:24 GMT

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?

Anonymous — Sun, 09 Aug 2015 08:01:10 GMT

Hi,

sorry for my delay.

Here is the qvw.

Elena