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

    Set Analysis - Expression not affected by selection

    nayan lalla

      Hi

       

      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)

        *

        NetWorkDays(vMinDate,vMaxDate,$(vRelativeHolidays)))).

       

      Thank you

       

      Kind regards

      Nayan