Qlik Community

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 
Search instead for 
Did you mean: 
pkelly
Specialist
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
sunny_talwar

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)

View solution in original post

4 Replies
sunny_talwar

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)

View solution in original post

greeshma_k
Creator III
Creator III

Try this

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

Clever_Anjos
Employee
Employee

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

And varToday should be formatted just like soo_LatestDate

pkelly
Specialist
Specialist
Author

Thanks everyone...