topic Re: Summing FROM-TO in QlikView

Summing FROM-TO

Wed, 07 Nov 2012 15:57:37 GMT

Hi everybody,

I'm facing a problem where i don't find a way to resolve it.

I'd like to do a sum with two conditions.

What I'd like to do (on my designer) is sum an import from Data_A to Date_B.

Something like:

SUM( {<Date >= $(vFrom) and Date <= $(vTo) "}>} Import)

IIs there a way to do that?

Thank you so much in advance.

Giampiero

jvitantonio — Wed, 07 Nov 2012 16:03:20 GMT

Hi, try this:

sum({$<Date={">=$(vFrom)},Date={"<=$(vTo)} >} Import)

Wed, 07 Nov 2012 16:11:41 GMT

Thank you so much.

It works perfectly.

I was on the right way but my expression was wrong

sum({<date= {"=date>= $(vFrom) "},date= {"=date<= $(vTo) "}>} Importo)

Again, THANK YOU so much

Giampiero

christian77 — Wed, 07 Nov 2012 16:24:57 GMT

I don't think so. You can call a field only once in a set.

I use single quotes.

Try this one...

sum({$<Date={'>=$(vFrom)<=$(vTo)'} >} Import)

Wed, 07 Nov 2012 16:28:35 GMT

Hi,

Thank you for reply.

Your solution works fine as well as the other one.

Thank you

Giampiero