Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2015-01-29 11:16 AM

Expression Average Total in Pivot

Hi,

I have a pivot chart with expressions that calculates the average customer visits as per the below formula:

avg(aggr(Count({$<DocType={'3'}>} DISTINCT CustCode),SmCode,Date))


My problem is that the total (partial sum) is not being calculated properly as it doesn't count the dates that have zero visits as shown below:

can you pls help me that?

Labels (1)
Labels
467 Views
0 Likes
0 Replies