topic Re: Applymap & subfield issues in QlikView

Applymap & subfield issues

Anonymous — Wed, 15 Jun 2016 09:51:26 GMT

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

Re: Applymap & subfield issues

sunny_talwar — Wed, 15 Jun 2016 09:56:47 GMT

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;

Re: Applymap & subfield issues

Anonymous — Wed, 15 Jun 2016 10:04:53 GMT

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

Re: Applymap & subfield issues

sunny_talwar — Wed, 15 Jun 2016 10:15:12 GMT

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;

Re: Applymap & subfield issues

Anonymous — Wed, 15 Jun 2016 10:24:17 GMT

Thanks Sunny. This has worked with Null()

Re: Applymap & subfield issues

qlikview979 — Wed, 15 Jun 2016 10:32:53 GMT

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;

Re: Applymap & subfield issues

Anonymous — Thu, 16 Jun 2016 05:38:24 GMT

Thanks Mahesh.. It helped