Applymap & subfield issues

[Anonymous]

I am having a field [Problem Owner] with values separated by a delimiter.example - [Problem Owner] = CA Andrew,CA Joseph
I need to plot a graph with Andrew and Joseph on the Y Axis to display the number of tickets resolved by them
Hence I used a subfiedd option and then used the applymap function to it
But when i verify the Y axis I not only get Andrew but other combinations with Andrew that are present in the base data . Can anybody please help me how to clean up the data and what can be done? I have attached my qvw file

[sunny_talwar]

Not sure I fully understand what you are trying to do, but may be this:

TEMP:

load  Ticket_Reference,

SubField(  Problem_Owner,',')as  Problem_Owner

Resident CA;

NewTemp:

load Ticket_Reference,

ApplyMap ('maptable',Problem_Owner) as New_Owner

Resident TEMP;

DROP Table TEMP;

[Anonymous]

Hi Sunny

It works but I need to plot only Andrew and Joseph that I have defined in the inline table. I dont see the field Owner to make it a list box or plot it in the Y axis

[sunny_talwar · Accepted solution]

That is because owner is part of a mapping load table which doesn't survive after the reload is finished. Its content should now be available in New_Onwer. Try to modify the code and see if New_Onwer just include those two names now

TEMP:

load  Ticket_Reference,

SubField(  Problem_Owner,',')as  Problem_Owner

Resident CA;

NewTemp:

load Ticket_Reference,

ApplyMap ('maptable',Problem_Owner, Null()) as New_Owner

Resident TEMP;

DROP Table TEMP;

[Anonymous]

Thanks Sunny. This has worked with Null()

[qlikview979]

Hi,

this is help full to you

TEMP:

load  Ticket_Reference,

SubField(  Problem_Owner,',')as  Problem_Owner

Resident CA;

NewTemp:

load Ticket_Reference,

ApplyMap ('maptable',Problem_Owner) as New_Owner

Resident TEMP;

DROP Table TEMP;

[Anonymous]

Thanks Mahesh.. It helped