Numbers don't stay consistent in pivot table

[wanyunyang]

Hi guys,

I created a pivot table in Qlik sense recording net sales of each sales rep. The first dimension is sales rep, second is customer. When I expand the first dimension (click "+" next to sales rep), net sales numbers change. Why the numbers don't stay consistent?

Thanks in advance!

[juraj_misina]

Hi,

this really depends on your expressions and chart settings. Can you post your expression?

Juraj

[kuczynska]

Hi there,

not sure what exactly you mean by "numbers change", however I did come across an issue whit high resolution numbers changing digits within decimal points in some of my pivots when I was expanding the dimensions. This could be the case here too. To stabilize your results you can either set a specific format in settings of your pivot table or you could use num() within your load script to always use the same format for your net sales.

I hope this helps!

Michalina

[wanyunyang]

SUM(Aggr(SUM(DISTINCT NetSales), [OrderNo]))

[juraj_misina]

OK. I don't think you EVER want to do Sum(DISTINCT NetSales). Leave that distinct out, your numbers will not change.

[wanyunyang]

It still changes.

[isingh30]

Please attach a screenshot of  Pivot table.

Thanks.

[wanyunyang]

I think it's because my data has some null customers with net sales. When the pivot table closes, the numbers include those net sales. But when it expands, the pivot table won't include them. How can I fix it?

[wanyunyang]

I think it's because my data has some null customers with net sales. When the pivot table closes, the numbers include those net sales. But when it expands, the pivot table won't include them. How can I fix it?

[juraj_misina]

Did you uncheck "Include null values" on the customer dimension? It should be checked if you want to include those customers.