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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
gborregoa
Partner - Contributor
Partner - Contributor

Avg with Aggr

Hello,

I have made this expression :

Avg( Aggr( Today()- (Date(DateRegister)),  A, B, C, D ))

In this expression try to bring the average days of sales made ​​to date on all the time

The problem is that if I select the year of 2011, I can not do that performs the calculation for those who have chosen the earlier date and need to seethe total of the year excluding sales

The possibility exists that you can integrate some"Set Expression" to pass all previous years

Something like this:

"{$ <YearMov = {'*'}, MonthMov = {'*'}, Weeknum = {'*'},canceled= {'0'}>}"

I just do not know where to place the "Set Expression"

Duda QV.jpg

Any Ideas

0 Replies