Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

wanyunyang
Contributor

Numbers don't stay consistent in pivot table

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!

12 Replies
juraj_misina
Valued Contributor

Re: Numbers don't stay consistent in pivot table

Hi,

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

Juraj

kuczynska
Contributor III

Re: Numbers don't stay consistent in pivot table

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
Contributor

Re: Numbers don't stay consistent in pivot table

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

juraj_misina
Valued Contributor

Re: Numbers don't stay consistent in pivot table

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

wanyunyang
Contributor

Re: Numbers don't stay consistent in pivot table

It still changes.

isingh30
Contributor III

Re: Numbers don't stay consistent in pivot table

Please attach a screenshot of  Pivot table.

Thanks.

wanyunyang
Contributor

Re: Numbers don't stay consistent in pivot table

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
Contributor

Re: Numbers don't stay consistent in pivot table

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
Valued Contributor

Re: Numbers don't stay consistent in pivot table

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