topic Re: Short names for values in a column in QlikView

Short names for values in a column

Anonymous — Sun, 27 Mar 2016 17:04:00 GMT

Hi All,

One column having too lengthy values(Not all values some values). i need to create short names for that. pls help me.

Regards,

Krishna

Re: Short names for values in a column

Anonymous — Sun, 27 Mar 2016 17:20:48 GMT

You could use the Left() function to create short names of only the first few dozen characters of the lengthy names you have.

Re: Short names for values in a column

Anonymous — Sun, 27 Mar 2016 17:26:07 GMT

Hi Bill

pls explain in detail.

Regards,

Krishna

Re: Short names for values in a column

Anonymous — Sun, 27 Mar 2016 18:21:54 GMT

Not really much detail to explain. Put the below in a text box and you'll see it shows the first 2 dozen characters of the string:

=Left('The quick brown fox jumps over the lazy dog',24)

Re: Short names for values in a column

sunny_talwar — Sun, 27 Mar 2016 20:17:00 GMT

Not sure of what you are trying to do but if you want to keep first letter of each word, you can try something like this:

KeepChar(Capitalize(FieldName), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') aa NewFieldName

Re: Short names for values in a column

MarcoWedel — Sun, 27 Mar 2016 21:40:41 GMT

If those are predefined values, you could use a mapping table and Applymap() to substitute the long values with short versions.

regards

Marco

Re: Short names for values in a column

ashfaq_haseeb — Mon, 28 Mar 2016 07:00:27 GMT

Hi,

Map long name with meaningful shot names and you can use Apply Map later to convert.

Regards

ASHFAQ

Re: Short names for values in a column

its_anandrjs — Mon, 28 Mar 2016 07:08:12 GMT

Can you provide some sample file to have a look that is better to solve problem.

Regards

Anand

Re: Short names for values in a column

Kushal_Chawda — Mon, 28 Mar 2016 07:09:11 GMT

Try like below

In below map table you can define the long values from field. Make sure that values are case sensitive.

Map:

mapping Load * inline [

MapFrom, MapTo

This is too long Name , short Name ];

Data:

load *,

mapsubstring('Map', YourFieldnameContainingLongValues) as NewField

From Table;