Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.


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!

Community Browser