10 Replies Latest reply: Aug 2, 2014 6:39 AM by Padma Paida RSS

    Setting labels for Column names

    ar eiuiew

        I have created a cyclic group including a couple of columns and added as a chart dimension,

        I like to show these columns in group in a way user would recognize them, i know i can rename them by Load or Qualify ... but isn't      there any other way to set a label alike?

      Thanks

        • Re: Setting labels for Column names
          Padma Paida

          Hi Arman

           

          if you want to edit the name of the dimension

          -go to chart properties

          - edit groups

          - edit again

          - select the dimension that you would like to change the name

          - then you can type the dimension name in the label box

          pl find below the image

          Label Edit Groups.GIF.gif

          thanks

          Padma

            • Re: Setting labels for Column names
              ar eiuiew

              Thank You dear Padma

              I knew it should be somewhere, i just couldn't find it

              • Re: Setting labels for Column names
                ar eiuiew

                Dear Friend, I got another question

                Comparative.png

                as you can see in the picture I modified the cyclic group you helped me with, but i like to change the the dimension values(1,4,9,16,25) labels to (very bad,bad,no opinion,good,very good) but don't change them in the data base, i just want to change the presentation of them, not the real data. is it possible?

                thanks again

                  • Re: Setting labels for Column names
                    Padma Paida


                    Hi

                     

                    You can edit the dimension as a expression

                    In my case I have edited Jan to 1 using an if formula

                    Please see below the image

                    Label Edit Groups.GIF.gif

                    Thanks

                    Padma

                      • Re: Setting labels for Column names
                        ar eiuiew

                        qlikoqlik dear friend, i tried what you told me. but it seems there's a problem in my expression, would you please take a look at it and tell me what's the problem?

                        cyclik.png

                        as you can see in the above image, i'd like to replace (1,4,9,16,25) values with (Highly disagree,disagree,...). but instead of doing this, i get nothing but an ( _ ) in the cyclic group. apparently this is some sort of error. isn't there something like case function in qlikview?

                        thanks a lot buddy

                          • Re: Setting labels for Column names
                            Michael Gardner

                            Combine all your Expressions into one field.  You created multiple expression fields when you should have created one.

                             

                            IF(A1 like '1' , 'Highly Disagree',

                                 IF(A1 like '4' , 'Disagree',

                                      IF(A1 like '9', 'No Opinion', etc...,

                                           A1)))

                              • Re: Setting labels for Column names
                                ar eiuiew

                                Did what you said exactly, but still doesn't work

                                Thanks by the way

                                  • Re: Setting labels for Column names
                                    Michael Gardner

                                    In the script you can create a new field in the table where that field exists and use mapping load and applymap.  This way you aren't changing the original field.

                                     

                                    //This is your mapping table

                                    A1Map:

                                    MAPPING LOAD * INLINE [

                                        A1, A1Description

                                        1, very bad

                                        6, bad

                                        9, no opinion

                                        16, good

                                        25, very good

                                    ];

                                     

                                    //Current existing table in Data Model

                                    Load

                                         *,

                                         Applymap('A1Map',A1) as A1Description

                                    From File Source;

                                      • Re: Setting labels for Column names
                                        ar eiuiew

                                        here is what i have in the script:

                                        script.png

                                        when i Reload, i get the following error:

                                        Cannot access file customersatisfaction.dbo.full.   i guess it's because of OLEDB connection. what should i do?  i also set a label for columns A1 to A12 in the edit group menu. is it necessary to repeat those labels here or no?

                                        Just to make sure we are on the same page, 1,2,9,16,25 are possible values of coulumn A1,A2,...A12, WHICH  i want to alias them as (Highly disagree,....)

                                        thanks again

                          • Re: Setting labels for Column names
                            Padma Paida

                            Hi Arman

                             

                            Sorry I haven't logged in for an while.  Please see below this should work.  in my example monthnumber is the field name, replace this with A1

                             

                            if(MonthNumber ='1','Highly Aggreeable',

                            if(MonthNumber ='4','Aggreeable',

                            if(MonthNumber ='9','Not Aggreeable',

                            MonthNumber )))

                             

                            Thanks and regards

                            PAdma