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