Pivort Table Calculation

Fri, 07 Aug 2015 08:30:42 GMT

Hi Qlikview

I want to display result set like fallowing

but I can do in qlik as fallows

I cant able to fit that format I am getting like above

opening count is previous month closing count , and net gain is opening count - closing count

I need all in straight line format like excel doing , opening count need to come under month 6 and net gain needs to come under bottom corner box where (-442221) displayed, value will be (439852 - 44222 = -2369) in bottom corner Box in Qlik

formulas I am using :

opening count ; Num(count({$<Classification = {'Existing Member'},DimMemberCountType_IsCountable = {'-1'},Year={$(vCurrentYear)},Month={$(vPrevMonth-1)}>}MemberKey),'#,##0;(#,##0)')

closing count: Num(count({$<Classification = {'Existing Member'},DimMemberCountType_IsCountable = {'-1'},Year={$(vCurrentYear)},Month={$(vPrevMonth-2)}>}MemberKey),'#,##0;(#,##0)')

vPrevMonth-1 = 6, vPrevMonth-2 = 5

Thanks

topic Pivort Table Calculation in QlikView

Pivort Table Calculation