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

Null values make pivot table numbers don't stay consistent

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. The formula is: SUM(Aggr(SUM(NetSales), [OrderNo]))

But my data has some null customers with net sales. When the pivot table closes, the numbers include those net sales. But when it expands (click "+" next to sales rep), the pivot table won't include them. How can I fix this? I don't want my net sales include those null customers when the pivot table closes.

Thanks in advance!