topic Re: Re: get the range sum in QlikView

get the range sum

Sun, 18 May 2014 05:13:18 GMT

the COMPANY &ORDATE is fixed data . When I input a date , I want to get the sum(qty) between ordate and input-date for every company.

Sun, 18 May 2014 05:17:20 GMT

the sample is as attached.

robert_mika — Sun, 18 May 2014 07:03:40 GMT

jack,

Are your data coming from Excel Pivot Table?

Do you have the raw sources of data?

Sun, 18 May 2014 07:24:25 GMT

The data is from database .Attached is a actual data which ordate is property of company+item(which compose a key_gobkey).

Mon, 19 May 2014 12:44:41 GMT

If you have Company as dimension, then expression:

sum( {<dealdate={"=INDATE<dealdate"}>*<dealdate={"<=$(=date(testdate))"}>} qty)

should work

regards

Darek

Tue, 20 May 2014 01:10:27 GMT

it seem no ok . the expressing dealdate={"=INDATE<dealdate"} don't work . pls see attached.

Tue, 20 May 2014 07:39:56 GMT

This must work:

sum( {<dealdate={"<=$(=date(testdate))"}>} if(INDATE<dealdate,qty))

regards

Darek