topic Re: Complex set analysis works only for equal sign(=) in QlikView

Complex set analysis works only for equal sign(=)

steliosg — Wed, 12 Dec 2012 21:22:23 GMT

Hello,

I'd like to make the below function works with sign >= instead of =

The initilal expression is

sum({$<CODE={'10'}, Date={"=Date(firstsortedvalue( {$<CashAmount={'>0'},Date= {'<$(=OpeningDate)'} >} Date,-Date),'DD/M/YYYY')"}>}Amount)

and it works.

The ideal is

sum({$<CODE={'10'}, Date={">=Date(firstsortedvalue( {$<CashAmount={'>0'},Date= {'<$(=OpeningDate)'} >} Date,-Date),'DD/M/YYYY')"}>}Amount)

but it doesn't work.

Any help will be welcomed!

Re: Complex set analysis works only for equal sign(=)

Anonymous — Wed, 12 Dec 2012 21:31:07 GMT

See if this helps, always works for me, my additions in bold:

sum({$<CODE={'10'}, Date={"$(= '>=' & Date(firstsortedvalue( {$<CashAmount={'>0'},Date= {'<$(=OpeningDate)'} >} Date,-Date),'DD/M/YYYY') )"}>}Amount)

Regards,

Michael

Re: Complex set analysis works only for equal sign(=)

steliosg — Wed, 12 Dec 2012 21:35:00 GMT

Thanks a lot Michael,

You save my night!

Best Regards