Create 1 new field from 4 existing / merge?

[#1]

Hi

I have two tables, EducationNR and EducationText. I want to sort the numbers and create a new text-table. Like this. 546,547,556 and 557 should be linked to a new textfield named University Education.  100,102 and 106 should be named as Lower Education and so on...

So when I click on Universty Education the posts correspondening to 546,547,556 and 557 should be shown.

I guess I do this in the script but how?

Attached my file

[swuehl · Accepted solution]

This sounds like a classical classification, right?

If the classification is static (not depending on selections), you want to do this in the script.

You can either do this using conditionals (maybe using some match() functions, too):

LOAD

EducationNr,

if( EducationNr >= 100 and EducationNR <=106, 'University',

if( EducationNr >=546 and EducationNr <= 557, 'Lower Education')) as EduClass,

...

FROM ...;

or e.g. using a mapping table, which is described here:

http://community.qlik.com/message/47282#47282

[#3]

Hmz swuehl was quicker than me, but I had a QVW already, so I'll just post it.

See the example attached 🙂

Here I have an if-construction and a match() construction

[#4]

Thanks both of you! A second thought. How can I (from the orginal fields) show only the highest number per ID in a straight table? = only show 546 if the person also have a 100.

[#5]

Have a chart (straight table) with ID as dimension and as expression max(EduNr) I guess.