Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator III
Creator III

Setting labels for Column names

  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

1 Solution

Accepted Solutions
Creator II
Creator II

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

View solution in original post

10 Replies
Creator II
Creator II

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

View solution in original post

Creator III
Creator III

Thank You dear Padma

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

Creator III
Creator III

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

Creator II
Creator II


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

Creator III
Creator III

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

Creator III
Creator III

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)))

Creator III
Creator III

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

Thanks by the way

Creator III
Creator III

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;

Creator III
Creator III

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