topic Penultimate date sales in dynamic table in QlikView

Penultimate date sales in dynamic table

cafcptg2011 — Thu, 10 Mar 2011 17:26:18 GMT

Hi,

PROBLEM: Is to display last date of sales in a given period in dynamic tab. i have attached a qvw file to show better my problem.

thanks in advance,

cafc

Thu, 10 Mar 2011 18:16:08 GMT

is this what you need?

=aggr( min(total {< sales_date = {'>=$(=date('01-03-2010')) <$(=date('03-03-2011'))'}, val={">0"}>} sales_date),val)

cafcptg2011 — Thu, 10 Mar 2011 18:21:59 GMT

thank you for your answer, but indeed is not what i need. I need simply the max (date) in a given period of time, you see?

thanks

cafc

Thu, 10 Mar 2011 18:29:03 GMT

cafcptg2011 — Thu, 10 Mar 2011 19:05:20 GMT

yes, but with your expression will given wrong dates for others customers, you see? so i took your expression and i adapted to this :

=aggr( max( {< sales_date = {">=$(=date('01-03-2010')) <$(=date('03-03-2011'))"}, val={">0"}>} sales_date),id_customer)

and its seem to be working now.

so, thank you very much.

cafc

Thu, 10 Mar 2011 19:30:35 GMT

hadn't seen your reply, kept working on it and this works too

=max({< sales_date = {'>=$(=date('01-03-2010')) <$(=date('03-03-2011'))'},val={">0"}>} sales_date)