Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
wanyunyang
Contributor II

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
Luminary
Luminary

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 II

Re: Numbers don't stay consistent in pivot table

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

Luminary
Luminary

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 II

Re: Numbers don't stay consistent in pivot table

It still changes.

isingh30
Valued Contributor

Re: Numbers don't stay consistent in pivot table

Please attach a screenshot of  Pivot table.

Thanks.

wanyunyang
Contributor II

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 II

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?

Luminary
Luminary

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.