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
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
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?

398 Views
0 Likes
0 Replies
Community Browser