Select a code from a smart field

Fri, 11 Mar 2011 23:14:27 GMT

Good evening,

I have a code made up of 10 digits where each piece represents an information.
An example:
abcdefghij
0123456789

"a" represents the continents - in which case 0 would be Africa.
"bc" represent countries - in this case would be Zimbabwe
"d" represents a state ....

and so on.

How to create lists?
Continents, countries, states, etc.

I need this because I have a table like this:

Code / Income / GDP

And now want to group (not sure if this is the right word), but wanted to make views by continent, country, state, etc. .

Any tips?

Hugs

Gledson

Select a code from a smart field

Oleg_Troyansky — Fri, 11 Mar 2011 23:22:46 GMT

I'd recommend creating Mapping Tables for each one of the lists, and then parsing the string into individual characters (using functions LEFT() and MID() ) and mapping individual characters to the corresponding fields, using the mapping tables.

topic Select a code from a smart field in QlikView

Select a code from a smart field

Select a code from a smart field