topic Re: How do I rename field values? in QlikView

How do I rename field values?

Anonymous — Wed, 21 Jan 2015 11:57:21 GMT

I have a field called 'group' and it has 6 possible values - '1. Under 10hr', '2. Under 40hr', '3. under 80h', '4. Under 160', '5. Under 320', '6. Over 320'.

The possible values aren't very clear. I would like to present these differently in all my charts and tables. I would like to rename them to - 'Under 10 hours', '10 up to 40 hours', '40 up to 80 hours', '80 up to 160 hours', '160 up to 320 hours', '320 hours up to FT'.

Is there a way to do this in the 'edit script'.?

Thanks

Greg

Re: How do I rename field values?

krishna20 — Wed, 21 Jan 2015 12:09:01 GMT

Edit this code below to group field .

Try like this

if(Group<0 ,Dual('<0',1),

if(Group>1 and Group<=10,Dual('1-10',2),

if(Group>=11 and Group<=40,Dual('11-40',3),

if(Group>=41 and Group<=80,Dual('41-80',4),

if(Group>=81 and Group<=160,Dual('41-160',5),

)))) as Hours_band

Hope this helps !!

Regards

Krishna

Re: How do I rename field values?

daveamz — Wed, 21 Jan 2015 12:24:29 GMT

Hello Greg,

This should work:

Pick(Match(group, '1. Under 10hr', '2. Under 40hr', '3. under 80h', '4. Under 160', '5. Under 320', '6. Over 320'), 'Under 10 hours', '10 up to 40 hours', '40 up to 80 hours', '80 up to 160 hours', '160 up to 320 hours', '320 hours up to FT')

It is very important to list the elements in the same order because first match will return first pick item and so on.

Or, you can use Mapping Load / Apply Map.

Regards,

David

Re: How do I rename field values?

MarcoWedel — Wed, 21 Jan 2015 12:26:35 GMT

=Dual(Pick(Match(group, '1. Under 10hr', '2. Under 40hr', '3. under 80h', '4. Under 160', '5. Under 320', '6. Over 320'),

'Under 10 hours', '10 up to 40 hours', '40 up to 80 hours',

'80 up to 160 hours', '160 up to 320 hours', '320 hours up to FT'),

Match(group, '1. Under 10hr', '2. Under 40hr', '3. under 80h', '4. Under 160', '5. Under 320', '6. Over 320'))

Re: How do I rename field values?

Wed, 21 Jan 2015 12:28:25 GMT

Hi Greg,

I answered something similar the other day, maybe have a look at this

http://community.qlik.com/thread/148849

hope that helps

Joe

Re: How do I rename field values?

MarcoWedel — Wed, 21 Jan 2015 12:28:39 GMT

Dual to let this field be sortable numerically.

Re: How do I rename field values?

rwunderlich — Wed, 21 Jan 2015 14:55:34 GMT

I would use a MAPPING load.

GroupMap:

MAPPING LOAD from, dual(to,RecNo()) INLINE [

from, to

1. Under 10hr, Under 10 Hours

2. Under 40hr, 10 to 40 Hours

etc

]

;

MAP Group USING GroupMap;

The dual() trick will set up a numeric value for sorting. Just list the rows in order in the mapping table.

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: How do I rename field values?

Anonymous — Wed, 21 Jan 2015 16:17:46 GMT

Krishna, Marco, David, Joe, Rob

Thank you for your assistance.

Greg

Re: How do I rename field values?

AshwinDaniel — Tue, 17 Aug 2021 15:28:14 GMT

Hello Gentlemen,

Is there any way to display Alias name for field values using expression.

I do have only two field values under a field "Eligible Criteria" (For example).

The first one has "Fuel Vehicle Eligible" which I would like to show as "Eligible" and next one "Not eligible due to" as "Not Eligible"

Thanks in advance!

@Anonymous @rwunderlich @MarcoWedel @daveamz @krishna20

Re: How do I rename field values?

rwunderlich — Wed, 18 Aug 2021 15:57:29 GMT

If("Eligible Criteria" = 'Fuel Vehicle Eligible', 'Eligible', 'Not Eligible')

Re: How do I rename field values?

AshwinDaniel — Thu, 19 Aug 2021 10:15:33 GMT

Dear @rwunderlich ,

Thank you for your assistance.

I would like to change the background color too based on the output. Is that possible using any chart?

Currently I am using "Text and Image"

Regards,

Ashwin Daniel

Re: How do I rename field values?

AshwinDaniel — Thu, 19 Aug 2021 11:24:02 GMT

Thank you for your assistance @rwunderlich , I played wrong with the single and double quotes.

Many thanks,

Re: How do I rename field values?

AshwinDaniel — Thu, 19 Aug 2021 11:26:04 GMT

Dear @rwunderlich ,

Could you please suggest me, which chart to use:

I would like to change the background color as RED when it is not eligible and GREEN on Eligible.

Many thanks in advance.

Re: How do I rename field values?

rwunderlich — Thu, 19 Aug 2021 23:23:34 GMT

You should start a new thread for these new questions. It's difficult to get answers when new questions are added to old posts.

-Rob

Re: How do I rename field values?

AshwinDaniel — Fri, 20 Aug 2021 06:42:33 GMT

Yes you are right @rwunderlich. I shall open this as a new thread Mr. Rob.

Regards,