Pivot Expanded count doesn’t equal to total count

[TheMdu]

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 

[dplr-rn]

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

[TheMdu]

Hi

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

[Brett_Bleess · Accepted solution]

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/ChartFunction...

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/Cou...

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

Regards,
Brett