topic Re: Pivot Expanded count doesn’t equal to total count in QlikView

Pivot Expanded count doesn’t equal to total count

TheMdu — Wed, 05 Jun 2019 14:43:59 GMT

Hi guys

I’ve created a pivot that shows total leads, distinct leads and sales. My dimensions are AgentName and LeadSource, and my expressions are count(distinct leads), count (total leads) and count sales. Now when the pivot is expanded, the individual count of sales does not add up to the total. It looks like I have more sales per lead source and that’s not the case. Count(Distinct Sales) doesn’t seem to help

Re: Pivot Expanded count doesn’t equal to total count

dplr-rn — Wed, 05 Jun 2019 19:46:34 GMT

too vague unfortunatly. can you share some screenshots. and some example of how the data looks like etc.

Re: Pivot Expanded count doesn’t equal to total count

TheMdu — Thu, 06 Jun 2019 06:04:59 GMT

I have attached the collapsed and expanded pivot.

Data is from 2 tables, one being SALES and the other LEADS.

Both tables have SalesPerson and Mobile as common fields, but the association here is made on Mobile.

expanded and collapsed pivot

Re: Pivot Expanded count doesn’t equal to total count

Brett_Bleess — Tue, 09 Jul 2019 16:33:41 GMT

Best I have is the following Help link that might help with this if what is going on are duplicate rows where things are getting dropped:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctions/NestedAggregations/sum-of-rows-pivot-tables.htm

You could also use RowNo or RecNo functions in the load script to make each row unique that way as well, but the above is likely a good thing to try first to see if that might do the trick for you. If that does not work, then look into RowNo and RecNo:

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/CounterFunctions/RowNo.htm

http://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/Scripting/CounterFunctions/RecNo.htm

Regards,
Brett