Field Display question

[userid128223]

Hi Everyone

I have field like this in excel.

Leader

YY

TT

JJ

YY, TT , JJ

Now in my dashboard, I have Inline table that matches each acronmyn to a name.

LOAD * INLINE [

    Leader, Leader Name

    YY, Ying Yang

    TT, Tim Tang

    JJ, Jim Jay

];

So now when i display on dashboard Ying Yang it corresponds to fields that are related to YY.

However if leaders are more then 1 like the last field YY, TT, JJ. this command is not understood by QlikView. How can you make QV interpret as 3 seperate names even thought it was entered in same field.

[jpapador · Accepted solution]

Use the subfield command and specify a delimiter:

Subfield(Leader, ',') as NewLeaderField

[swuehl]

Either load your first table in using subfield, i.e. generate 3 records from your last field value:

LOAD

     trim(subfield(Leader, ', ')) as Leader,

     ...

or try mapping your inline values:

MAP:

MAPPING LOAD * INLINE [

  Leader, Leader Name

    YY, Ying Yang

    TT, Tim Tang

    JJ, Jim Jay

];

LOAD

     mapsubstring('MAP', Leader) as Leader,

     ....

this will keep your three leader names in one field value.

[userid128223]

There is problem doing it this way since in the table chart i want to show project that has multple leader in same line instead of 3 lines.

[swuehl]

Ok, that's why I suggested the mapping approach?