Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

joeybird
Contributor II

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

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

1 Solution

Accepted Solutions

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

May be add another 1 here

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

2 Replies

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

May be add another 1 here

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

joeybird
Contributor II

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

Hi

Thanks team, star as always x

Kind Regards

Community Browser