topic Re: STACK CHART ISSUE in QlikView

STACK CHART ISSUE

Thu, 16 Jul 2015 01:31:27 GMT

I would Like to do a Stacked Bar Chart for the Above Data with Dim1 as First Dimension and Quarter as Second Dimension.

Sales 1 and Sales 2 are the Metrics.

I would like to accomplish the Stacked Bar Chart as shown in the Attached file.

Any Help is appreciated

Gysbert_Wassenaar — Thu, 16 Jul 2015 16:29:27 GMT

See attached qvw.

Thu, 16 Jul 2015 16:57:14 GMT

Thnx for the help , but no attachment

Thu, 16 Jul 2015 17:08:07 GMT

Got the Attachment, Thnx will review

Thu, 16 Jul 2015 17:42:12 GMT

Its very helpful, but Sales1 and Sales2 are a part of a big Data Set, I cant Pivot the other fields in there. like you are doing in the Crosstable

Gysbert_Wassenaar — Thu, 16 Jul 2015 17:49:13 GMT

Perhaps a synthetic dimension works. See attached qvw.

Fri, 24 Jul 2015 13:22:40 GMT

Your QVW works gr8 for the sample data set I posted, but when I apply the same logic to my actual Data Set, I dont get Quarters to stack up.

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'))))

I Expect the Quarters to Stack up on Each Bar. Please help