Set Analysis Syntax

[#1]

Hallo,

I'm new in QlikView and here is my problem:

I want to build a sum when following condition is true.

If startfield >= sfield and (endfield <= efield or endfield is null) then build a sum.

Hope anyone can help me.

Thanks in advance

Heinz

[giakoum]

Try something like :

sum({$<[StartField]={">=$(vFromDate)"}, [EndField]={"<=$(vToDate)"} + [EndField]={"=$(null())"}>} [Sales])

maybe EndField must not be duplicated :

sum({$<[StartField]={">=$(vFromDate)"}, [EndField]={"<=$(vToDate)"} + {"=$(null())"}>} [Sales])

[#3]

Thanks Ioannis,

this helps me to go on.

Greetings

Heinz