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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Build a aggr Function

Hi,

is it possible to create an aggr expression from this formula count(ID) / count(Distinct date)...

Please look at my example.

Thank you

Labels (1)
3 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Sure, you can create thousands of aggr expressions based on that. But what are you trying to calculate?


talk is cheap, supply exceeds demand
sunny_talwar

What exactly is your requirement? The attached file doesn't tell anything about what you are trying to achieve

Not applicable
Author

The aggr function should give the same result like the expression count(ID) / count(Distinct date) in a pivot table with only dimension interval...