topic Re: Pivot table calculated dimension in QlikView

Pivot table calculated dimension

suresh_qv50 — Sun, 10 Apr 2016 10:44:58 GMT

Hi Every one,

I was create a pivot table, Created drill down group as QMDDrill, this is 1st dimension. 2nd dimension is calculated condition based on group .

i wrote as

=if(GetCurrentField(QMDDrill)='Quarter',num(aggr(sum(DueAmt),Quarter),'$#,##0.;($#,##0.00)'),

if(GetCurrentField(QMDDrill)='Month',num(aggr(sum(DueAmt),Month),'$#,##0.;($#,##0.00)'),

if(GetCurrentField(QMDDrill)='Duedate',num(aggr(sum(DueAmt),Duedate),'$#,##0.;($#,##0.00)'),)))

this was working fine but Getting wrong result. Can any one give alternate solution for this

Thanks in Advance

swuehl — Sun, 10 Apr 2016 12:21:56 GMT

Could you elaborate further on what numbers you expect to see and what you get.

Best by uploading a small sample QVW and your requested results.

sunny_talwar — Sun, 10 Apr 2016 12:29:00 GMT

Not sure what you mean when you say wrong result. May be if you can provide a sample with your expected output, we are able to help better.