topic sum untill date in QlikView

sum untill date

Anonymous — Mon, 22 Sep 2014 03:32:23 GMT

i have date created for each item, i want to calculte sum(kg) for each item untill his date created and after date created.exm:

item no.1, date created 01/09/14

sum kg untill 01/09/14 - 140 kg

sum kg from 01/09/14 - 120 kg

how i need to write this experssion in pivot ?

hope it's understood.

thanks'

yarin.

sujeetsingh — Mon, 22 Sep 2014 03:48:46 GMT

Can you explain in more words

senpradip007 — Mon, 22 Sep 2014 03:56:56 GMT

Try like

Sum({<Date={"<=$(=Date(Max(Date),'DD/MM/YYYY'))"} >} [Your Field])

senarath — Mon, 22 Sep 2014 04:07:27 GMT

Hi,

I think you require something like =aggr(sum(Kg),Date)

thanx