topic Re: Pivot table totals showing wrong in QlikView

Pivot table totals showing wrong

rajaqliks — Fri, 08 Feb 2019 05:31:23 GMT

Hi Folks,

I have created one pivot table, values are showing correct, but totals are not showing correct values , for reference purpose i am adding QVW .

Thanks in advance

Re: Pivot table totals showing wrong

gn_marvs1989 — Fri, 08 Feb 2019 06:25:34 GMT

Would this be the solution you need? see attachment

Re: Pivot table totals showing wrong

rajaqliks — Fri, 08 Feb 2019 06:46:07 GMT

same error, i didn't get the solution

in qvw we have two chart one is bar and second one is pivot table bar graph is showing correct values but the pivot table is not show the correct values in totals please check and help me

Re: Pivot table totals showing wrong

rajaqliks — Fri, 08 Feb 2019 06:49:50 GMT

compare the values with bar graph chart

Re: Pivot table totals showing wrong

tresB — Fri, 08 Feb 2019 07:07:44 GMT

You can try putting an aggregation function around your expression in pivot expression like:

Sum( Aggr ( If(.....) , Contact_Type, WEEKEND))

Re: Pivot table totals showing wrong

tresB — Fri, 08 Feb 2019 07:07:58 GMT

You can try putting an aggregation function around your expression in pivot expression like:

Sum( Aggr ( If(.....) , Contact_Type, WEEKEND))

Re: Pivot table totals showing wrong

rajaqliks — Fri, 08 Feb 2019 07:18:30 GMT

Thank you very much Tresesco its working great

Re: Pivot table totals showing wrong

gn_marvs1989 — Fri, 08 Feb 2019 07:52:18 GMT

Try this; You need to use the Aggr()

sum(aggr( if(GetFieldSelections(MDESC)='TargetOnly',count({=' & Date(Max(WEEKEND) - 77, 'MM/DD/YYYY') & '<=' & Date(Max(WEEKEND), 'MM/DD/YYYY'))"},RightfulOwner={'Y'},TargetFlag={'1'}>}DISTINCT Key), if(GetFieldSelections(MDESC)='Total Territory',count({=' & Date(Max(WEEKEND) - 77, 'MM/DD/YYYY') & '<=' & Date(Max(WEEKEND), 'MM/DD/YYYY'))"},RightfulOwner={'Y'}>}DISTINCT Key), if(GetFieldSelections(MDESC)='Full Universe',count({=' & Date(Max(WEEKEND) - 77, 'MM/DD/YYYY') & '<=' & Date(Max(WEEKEND), 'MM/DD/YYYY'))"}>}DISTINCT Key)))) ,WEEKEND,Contact_Type))

Re: Pivot table totals showing wrong

rajaqliks — Fri, 08 Feb 2019 07:56:37 GMT

Hi totals are working fine but Weekly avg and totals are not working could you please help me on that,

i am adding qvw for reference.

Re: Pivot table totals showing wrong

rajaqliks — Fri, 08 Feb 2019 07:57:38 GMT

Here is the qvw

Re: Pivot table totals showing wrong

robin_heijt — Fri, 01 Mar 2019 09:46:02 GMT

Hi,

I was having the same issue, and this resolved it.
Could you potentially explain to me why the Aggr is needed and how it affects the measure?
I would like to understand how it works.

Thanks,.