1 Reply Latest reply: Jul 16, 2016 8:51 AM by Onno van Knotsenburg RSS

    QlikView Expression not working in Qlik Sense

    Laleh Haidari

      Hi,

      I have a chart expression as below which does not work in Qlik Sense. Does anyone know why this is happening?

       

       

      if(

      rangemax(

      fabs(Column(2)),fabs(Column(4))

      ), //supress 0 rows

       

       

      concat(DISTINCT

      {$<

          Month=

             ,SourceType={'ACC'}

             ,[Month Year]={"$(vCurrMonthYear)"}

      >} Description

      , ',')

      &

      concat(DISTINCT

      {$<

          Month=

             ,SourceType={'P&L'}

             ,Department={'999'}

             ,[Month Year]={"$(vCurrMonthYear)"}

      >} Description

      , ',')

      )