Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sanjyotpatkar
Creator III
Creator III

Applymap & subfield issues

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

1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

6 Replies
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;

sanjyotpatkar
Creator III
Creator III
Author

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

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;

sanjyotpatkar
Creator III
Creator III
Author

Thanks Sunny. This has worked with Null()

qlikview979
Specialist
Specialist


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;

sanjyotpatkar
Creator III
Creator III
Author

Thanks Mahesh.. It helped