2 Replies Latest reply: Aug 3, 2018 9:52 AM by Joanna Seldon RSS

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

    Joanna Seldon

      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