topic Re: Facing issue in Total in Pivot Chart in QlikView

Facing issue in Total in Pivot Chart

Anonymous — Tue, 21 Mar 2017 07:52:13 GMT

Hey guys,

Please find the below Pivot chart table output where i m finding incorrect Total

Tried using Dimensionality() in the expression

IF Dimensionality()=0,(sum of the field1 + sum of the existingexpression1)

Even tried using Aggr() on the basis of Material and Date but still total is coming 413.33051 which i wrong.

Please help me to resolve the issue.

Thanks & Regards,

Girish Chhatani

migueldelval — Tue, 21 Mar 2017 07:53:42 GMT

Hi Girish,

Could you attach a data sample?

In my example "Total" it´s correct.

Regards

Miguel del Valle

Anonymous — Tue, 21 Mar 2017 09:36:57 GMT

Hi Miguel,

Thanks for the prompt reply.

Please find the attached Excel which contains the sample data along with the Expected Output.

Thanks & Regards,

Girish Chhatani

migueldelval — Tue, 21 Mar 2017 10:11:55 GMT

Hi Girish,

Your problem is that you aren´t managign '.' and ','; check my example and check output.

Anonymous — Tue, 21 Mar 2017 10:16:46 GMT

Hi Miguel,

I checked and found once i changed the Chart type to Pivot chart total numbers are changing.

Thanks & Regards,

Girish Chhatani

Frank_Hartmann — Tue, 21 Mar 2017 10:36:40 GMT

see attached

hope this helps

migueldelval — Tue, 21 Mar 2017 10:41:08 GMT

Hi Girish,

Do you finally solve your question?

Please close your question or tell me if you need something more.

Regards

Miguel del Valle