zeros appearing for future months

[rcorcoran]

Hi

I have the code below in a pivot table.  My problem is that it is showing data fine but is showing zero for future months - ex June 2015 etc.  The percentage expressions don't but the others do.  Any way of stopping this and only showing zero if the zero value is a returned value

Thanks in advance

Pick(Match(ValueList('Number of Psychiatry of Old Age Community Mental Health Teams',
'Number of referrals (including re-referred)received by Psychiatry of Old Age Mental Health Teams',
'Number of Referrals (including re-referred) accepted by Psychiatry of Old Age Community Mental Health Teams',
'No. of new (including re-referred ) Old Age Psychiatry Team cases offered first appointment for the current month (seen and DNA below)',
'No. of new (including re-referred) Old Age Psychiatry Team cases seen in the current month',
' No. of new (including re-referred) Old Age Psychiatry cases offered appointment and DNA in the current month',
'%. of new (including re-referred) Old Age Psychiatry Team cases offered appointment and DNA in the current month',
'Number of cases closed/discharged by Old Age Psychiatry Community Mental Health Teams'),



'Number of Psychiatry of Old Age Community Mental Health Teams',
'Number of referrals (including re-referred)received by Psychiatry of Old Age Mental Health Teams',
'Number of Referrals (including re-referred) accepted by Psychiatry of Old Age Community Mental Health Teams',
'No. of new (including re-referred ) Old Age Psychiatry Team cases offered first appointment for the current month (seen and DNA below)',
'No. of new (including re-referred) Old Age Psychiatry Team cases seen in the current month',
' No. of new (including re-referred) Old Age Psychiatry cases offered appointment and DNA in the current month',
'%. of new (including re-referred) Old Age Psychiatry Team cases offered appointment and DNA in the current month',
'Number of cases closed/discharged by Old Age Psychiatry Community Mental Health Teams'),

' ',
num((((Sum({$<[POA]={1,2},ReferredMM={1}>}ActualValue)))), '##0'),
num((((Sum({$<[POA]={1},ReferredMM={1}>}ActualValue)))), '##0'),
num((((Sum({$<[POA]={3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30},ReferredMM={1}>}ActualValue)))), '##0'),
num((((Sum({$<[POA]={3,5,7,9,11,13,15,17,19,21,23,25,27,29},ReferredMM={1}>}ActualValue)))), '##0'),
num((((Sum({$<[POA]={4,6,8,10,12,14,16,18,20,22,24,26,28,30},ReferredMM={1}>}ActualValue)))), '##0'),
num(Sum({$<[POA]={4,6,8,10,12,14,16,18,20,22,24,26,28,30},ReferredMM={1}>}ActualValue)/Sum({$<[POA]={3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30},ReferredMM={1}>}ActualValue), '##0%'),
num(Sum({$<[POA]={31,32,33},ReferredMM={1}>}ActualValue), '##0'))

[Gysbert_Wassenaar]

Can you post a qlikview document that demonstrates the problem?

[#3]

PLEASE UPLOAD YOUR  DOCUMENT FOR REVIEW

THANKS