topic Re: Set Analysis Syntax in QlikView

Set Analysis Syntax

Tue, 14 Aug 2012 12:36:10 GMT

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 — Tue, 14 Aug 2012 12:55:00 GMT

Try something like :

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

maybe EndField must not be duplicated :

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

Wed, 15 Aug 2012 07:44:17 GMT

Thanks Ioannis,

this helps me to go on.

Greetings

Heinz