Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

STACK CHART ISSUE

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

0 Replies