Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
joeybird
Creator III
Creator III

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
sunny_talwar

May be add another 1 here

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

View solution in original post

2 Replies
sunny_talwar

May be add another 1 here

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

joeybird
Creator III
Creator III
Author

Hi

Thanks team, star as always x

Kind Regards