Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try something like :
sum({$<[StartField]={">=$(vFromDate)"}, [EndField]={"<=$(vToDate)"} + [EndField]={"=$(null())"}>} [Sales])
maybe EndField must not be duplicated :
sum({$<[StartField]={">=$(vFromDate)"}, [EndField]={"<=$(vToDate)"} + {"=$(null())"}>} [Sales])
Thanks Ioannis,
this helps me to go on.
Greetings
Heinz