zeros appearing for future months

rcorcoran — Wed, 20 May 2015 08:57:55 GMT

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

Re: zeros appearing for future months

Gysbert_Wassenaar — Wed, 20 May 2015 09:44:48 GMT

Can you post a qlikview document that demonstrates the problem?

Re: zeros appearing for future months

Wed, 20 May 2015 09:48:00 GMT

PLEASE UPLOAD YOUR DOCUMENT FOR REVIEW

THANKS

topic zeros appearing for future months in QlikView

zeros appearing for future months

Re: zeros appearing for future months

Re: zeros appearing for future months