4 Replies Latest reply: Jan 19, 2017 11:59 AM by nayan lalla RSS

    Set Analysis - Expression not affected by selection

    nayan lalla



      I have this expression below with set analysis where part of it is not affected by "Day" selection.  See highlighted in red below.

      However, when i choose a value in my "Day" list box, the value changes.  Is there another way to rewrite this expression.

      The Day represents days in a calendar month.


      Sorry, I am unable to attached the Qlikview Model.


      if([Has Target] = 'Yes', (sum({$<Date=, [Date] = {">=$(vBeginMonth) <=$(vMaxDate)"},[Has Target] = {'Yes'}, Day=>}Target)




      Thank you


      Kind regards