3 Replies Latest reply: Apr 17, 2017 10:12 PM by Ryan Wang RSS

    Reset dimension(QlikView)

    Ryan Wang

      Hi Guys,

      There is a requirement about dimension, for example:

      if (dimension1='abc','link-abc',dimension1).

      "link-abc" is from excel, so I want maintain the "link-abc" by excel, can I achieve this requirement?


      Many Thanks

      Ryan Wang

        • Re: Reset dimension(QlikView)
          Shiva Nagesh

          Can you please be more specific, with a screenshot if possible.

          • Re: Reset dimension(QlikView)
            Karunpreet Soni

            Hi Ryan,


            As per my understanding of your requirement, you can use the below expression


            if ( Match(Dimension1, 'abc'), 'link-abc', Dimension1)      AS NewDimension


            or else if you want 'link-abc' to be coming from excel, then you can store this value in  a variable (supposedly: vExcelLink) and change the expression to ,


            if ( Match(Dimension1, 'abc'), '$(vExcelLink)', Dimension1)      AS NewDimension

            Please do let me know for any concerns on the same.