topic Problem In Sum in QlikView

Problem In Sum

vijayit43 — Mon, 27 Apr 2015 19:35:49 GMT

Hi Expert,

In My data 5 field CustomerCode,OrderNo,ReleaseDate,PendingDate,Qty and one variable field vDate we want to sum those data which vDate is greater than(>) ReleaseDate and vDate is less than(<) PendingDate, how to write condition please suggest.

Re: Problem In Sum

maxgro — Mon, 27 Apr 2015 19:49:24 GMT

if date fields and variable have the same format

sum({$ <ReleaseDate={"<$(vDate)"}, PendingDate>{">$(vDate)"}>} somefield)

Re: Problem In Sum

JonnyPoole — Mon, 27 Apr 2015 19:49:41 GMT

The exact syntax could be different but you can use an if() condtion or Set Analysis to do this:

1. Sum( if( ReleaseDate > $(vDate) and PendingDate < $(vDate), Qty) )

2. Sum ( {<ReleaseDate={">$(vDate)"},PendingDate={"<$(vDate)"}>} Qty )

If neither works as is, see if you can post an app.

Re: Problem In Sum

petter — Mon, 27 Apr 2015 19:49:49 GMT

Sum( { <ReleaseDate = { "<$(Num(vDate))" } , PendingDate = { ">$(Num(vDate))" } > } Qty )

I think ... and maybe you should have <= and >= instead ? Inclusive ....

Re: Problem In Sum

Anonymous — Mon, 27 Apr 2015 22:23:20 GMT

sum({$<RealeaseDate={"<=$(vDate)"},PendientDate={">=$(vDate)"}>}Field)