Set Analysis

spsrk_84 — Thu, 29 Aug 2013 12:01:38 GMT

Hi All,

I have scenario where the report is pivot table & i want to do the accumulation in this.My dimensions is Qtr week i.e. it will have values 1,2,...13.

I have written a set analysis expression in this pivot table & i want to do the accumulation .

Pivot Table expression:

NUM(

SUM({<ProductSegment_Flag={1},Segment_SMB_Flag={1},FocusedCountryFlag={1},Year=,Quarter=,

QuarterNum={$(=vSelectedYrQuarter-10)},

[Analysis Fiscal Qtr Week]={"<=$(=ONLY([Analysis Fiscal Qtr Week]))"}>}$(vBookingsCurrency))

/$(vSymbol), '$(vCurrencySymbol) #,##0.0')

In this expression I used only function to see the values in another expression it is howing the proper values but when with in the set analysis Null value is passed.

Let me know ur suggestions/feedback how to achieve the accumulation in Pivot table.

Thanks,

Shiva

topic Set Analysis in QlikView

Set Analysis