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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
harithadogiparthi505
Contributor III
Contributor III

90 day rolling average showing error when multiple weeks gets selected in pivot table.

Hello,

I am getting an error when representing 90 day rolling average in pivot table.

avg(aggr(avg({<date={">=$(=date(max(date)-90,'MM/DD/YYYY')) <=$(=date(max(date),'MM/DD/YYYY'))"}>}COUNT),[File Number],[Day]))

when selecting one week dates in date range picker, the values were good enough.

when selecting 2 weeks in date range picker the first week values are good and second week values are showing null in pivot table.

Kindly help me in resolving this issue when calculating 90 days rolling average.

Any help greatly appreciated.

Labels (1)
0 Replies