topic Sum of date range in QlikView

Sum of date range

Tue, 23 Nov 2010 11:05:36 GMT

What I am trying to acheive is to sum up the SOTD_QTY_UNITS_ORDERED for the last 3 weeks.

Using these forums I have got to the point below however the formula produces 0 as the value:

Sum( {$< InvoiceDate = {"<$(=date(today(1), 0)>=$(=date(today(1)-21)"}>} sum(SOTD_QTY_UNITS_ORDERED))

Is there something wrong with the formula?

Thanks, Gareth

Tue, 23 Nov 2010 11:34:29 GMT

Hi Garethj1,

Try the following:


=sum({$<InvoiceDate={'>=$(=date(Today(1)-21,'DD/MM/YYYY')) <$(=date(today(1),'DD/MM/YYYY')) '}>} SOTD_QTY_UNITS_ORDERED)

Regards.

Tue, 23 Nov 2010 11:58:30 GMT

Thanks Miguel.

Just one more question on this:

If I needed to replace the Dimension SOTD_QTY_UNITS_ORDERED with the variable " _exp_CASE" how would I write this?

Tue, 23 Nov 2010 12:25:19 GMT

Hi,

I don't know what say about this, I would need to know what is the expression into the variable.

Regards.

Tue, 23 Nov 2010 12:45:51 GMT

Ah right the penny dropped - Cracked it.

Thanks for all your help, Gareth