topic Re: Set Analysis in QlikView

Set Analysis

pkelly — Mon, 17 Aug 2015 12:11:30 GMT

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

sunny_talwar — Mon, 17 Aug 2015 12:15:42 GMT

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)

Anonymous — Mon, 17 Aug 2015 12:16:07 GMT

Try this

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

Clever_Anjos — Mon, 17 Aug 2015 12:21:46 GMT

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

And varToday should be formatted just like soo_LatestDate

pkelly — Mon, 17 Aug 2015 12:23:19 GMT

Thanks everyone...