Qlik Sense - Ignore selections with > + < join within expression

[joeybird]

Hi

I have the following IF in a KPI, this uses > + < join  in the expression

here is the expression

sum({1

<[WeekStartDate] = ,[WeekStart] = ,[Date] = {'>=$(=vMinWeek)'}> + <[WeekStartDate] = ,[WeekStart] = ,[OrderInProgress] = {0}>

}if([WeeksWaitedFlag] + vWeekAdjust = Weeks,CurrentWeekFlag,0))

I have in the load added {1} to the vMinWeek, with no joy, selections still affect the expression.

please help

[sunny_talwar · Accepted solution]

May be add another 1 here

Sum({1<[WeekStartDate] = ,[WeekStart] = ,[Date] = {'>=$(=vMinWeek)'}> + 1<[WeekStartDate] = ,[WeekStart] = ,[OrderInProgress] = {0}>} if([WeeksWaitedFlag] + vWeekAdjust = Weeks,CurrentWeekFlag,0))

[joeybird]

Hi

Thanks team, star as always x

Kind Regards