topic Re: aggr function not working in QlikView

aggr function not working

Wed, 17 Oct 2012 11:28:15 GMT

here is what I'm trying to do:

=aggr(avg({<Versand_Dat.VERSADAT = {'>=$(=(Today() - $(vMaxWoche) * 7))<=$(=(Today() - $(vMinWoche) * 7))'}>}Versand_Dat.VERSADAT),Versand_Dat.IDENTNR)

Im trying to get the avg shipping date for every productID and then in my chart I want the ProductID(Versand_Dat.IDENTNR) to be shown but there is always the date shown does anyone know why maybe Im handling the aggr function wrong I appriciate any help even the explanation of the aggr function from scratch

regards,

Re: aggr function not working

swuehl — Wed, 17 Oct 2012 11:39:43 GMT

MT, your aggr() function is building an in-chart / inline table with dimension IDENTNR and an average VERSADAT as expression.

Not sure why you expect to see IDENTNR as outcome, or what you want to do with the VERSADAT then (or how you get to the IDENTNR from the avg VERSADAT).

Re: aggr function not working

giakoum — Wed, 17 Oct 2012 11:43:53 GMT

Aggr is used to aggregate the expression included.

So what you do here is aggregating the avg over productid. For each product id, this function will return a date value. If you use it in a chart, you simply need the poduct id as a dimension, no aggr needed.

maybe some more info would help.