2 Replies Latest reply: Aug 25, 2017 3:39 AM by Marat Abdullaev RSS

    Dynamic set modifier

    Marat Abdullaev

      In Qlik Sense 3.0 I used below code to make a dynamic set modifier.

      It was working perfect. All fields from Dim_Calendar were ignored if selected.

      It was a great way to ignore: date, week, month, year, etc. selections

       

      worked in QS 3.0

      ******************************************

      Sum({$<

                   $(='[$(=Concat({1<$Table={'Dim_Calendar'}>}distinct $Field,']=,[')&']=')')

      >}M_Quantity)

      ******************************************

       

      However after upgrading to QS June 2017 this code stopped working.

       

      Anyone who can help?