topic Re: Field Display question in QlikView

Field Display question

userid128223 — Tue, 18 Feb 2014 22:22:54 GMT

Hi Everyone

I have field like this in excel.

Leader

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.

Re: Field Display question

jpapador — Tue, 18 Feb 2014 22:25:40 GMT

Use the subfield command and specify a delimiter:

Subfield(Leader, ',') as NewLeaderField

Re: Field Display question

swuehl — Tue, 18 Feb 2014 22:29:28 GMT

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.

Re: Field Display question

userid128223 — Tue, 18 Feb 2014 22:37:32 GMT

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.

Re: Field Display question

swuehl — Tue, 18 Feb 2014 23:37:09 GMT

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