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.


            Regards

            Karunpreet