topic Set Identifier not Working in QlikView

Set Identifier not Working

Tue, 03 Dec 2013 21:15:06 GMT

Can anyone tell me why this expression is not selecting all records (ignoring the current selections)?

=(Sum({1<[B YearPeriod] = {"<=$(=Max([B YearPeriod]))"} >}[B Actual Amount]))

/(Sum({1<[B YearPeriod] = {"<=$(=Max([B YearPeriod]))"} >}[Budget Amount]))

swuehl — Tue, 03 Dec 2013 21:27:14 GMT

You probably need to add the set identifier also to the max functions:

=(Sum({1<[B YearPeriod] = {"<=$(=Max({1}[B YearPeriod]))"} >}[B Actual Amount]))

/(Sum({1<[B YearPeriod] = {"<=$(=Max({1}[B YearPeriod]))"} >}[Budget Amount]))