Discussion Board for collaboration related to QlikView App Development.
I wanted to calculate the average interval days between consecutive dates. I found the interval using the following expression,
Interval(Below(date(ORDERDATE)) - date(ORDERDATE),'d')
I tried using the following expression, Aggr(Avg(Interval(Below(date(ORDERDATE)) - date(ORDERDATE),'d')))
it throws me an error in expression saying Below function is not allowed inside aggregation.
I am actually trying to get the table like,
I have attached the sample file for your convenience.
Thanks in advance!!
Avg(total <Group> Aggr(
View solution in original post
Thanks for helping me with the expression. It works for good.