topic Qlik Sense - Ignore selections with > + < join within expression in App Development

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

joeybird — Fri, 03 Aug 2018 12:38:40 GMT

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

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

sunny_talwar — Fri, 03 Aug 2018 12:40:42 GMT

May be add another 1 here

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

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

joeybird — Fri, 03 Aug 2018 13:52:04 GMT

Thanks team, star as always x

Kind Regards