# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for
Did you mean:
Specialist

## Set Analysis

Hi...

Have the following set analysis expression...

='Due: Overdue: ' & num(Sum({< soo_LatestDate = {"\$(<varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue),'£ #,##0;(##,##0)')

I know that I can do this easily with an IF statement but am trying to learn set analysis...

Basically trying to show the value of late sales orders in a text box for product families 1 and 2.

O know for definite that there are some but this expression is returning zero.

varToday is a variable which holds todays date = soo_LatestDate field an date variable are in format DD/MM/YYYY

Any assistance greatly appreciated.

Regards

Paul

1 Solution

Accepted Solutions
MVP

Lets focus just on the expression, formatting can be done later. Try this may be:

=Sum({< soo_LatestDate = {"<\$(varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue)

4 Replies
MVP

Lets focus just on the expression, formatting can be done later. Try this may be:

=Sum({< soo_LatestDate = {"<\$(varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue)

Creator III

Try this

='Due: Overdue: ' & num(Sum({< soo_LatestDate = {"<\$(varToday)"}, soo_FamilyCode = {'01', '02'} >} soo_RemainingValue),'£ #,##0;(##,##0)')

Employee

"\$(<varToday)" should be "<\$(=varToday)"

And varToday should be formatted just like soo_LatestDate

Specialist
Author

Thanks everyone...

Community Browser