Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

Complex set analysis works only for equal sign(=)

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!

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

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

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

View solution in original post

2 Replies
Highlighted
Champion III
Champion III

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

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

View solution in original post

Highlighted
Partner
Partner

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

Thanks a lot  Michael,

You save my night!

Best Regards