Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Copy data from one field to another field

Hi,

I have a Oracle database for showing the Incidents data. The columns are Country, Company and many more. I need to show a graph as Region wise. The regions are North, South Europe, Americas, APAC. I mapped this with Regions excel as per the attachment using Country Column. But for some incidents Country column is blank. So while loading the data if the Country column is blank, then the value in Company should be filled in Country. I am using the following command, but Country is showing 0 after loading. Please assist.

LOAD incidenttype123,

     OpCategorizationTier1123,

     SupportGroup123,

      If(IsNull(Country123),Company,Country123) as Country123,

     ["Fact Ticket"."Incident Number"],

     ["Fact Ticket"."Customer Organization Technical Id"],

     ["Fact Ticket"."Reported Date"],

     ["Fact Ticket"."Submitter"],

     ["Fact Ticket"."Assignee"],

     ["Fact Ticket"."Last Resolved Date"],

     ["Fact Ticket"."Description"],

     ["Region"."ITSS"],

     ["SLM Status"."SLM Status"],

     ["Priority"."Priority"],

     ["Support Organization"."Support Company"],

     SupportOrganization123,

     ["Operational Category"."Operational Cat Tier2"],

     ["Operational Category"."Operational Cat Tier3"],

     ["Status"."Status"],

     ["Calendar Day"."Year Code"],

     ["Calendar Day"."Month"],

     ["Calendar Day"."Day Code"],

     ["Calendar Day"."Quarter"],

     custcomp,

     ["Impact"."Impact"],

     ["Fact Ticket"."Additional Info"],

     ["Fact Ticket"."Closed Date"],

     ["Fact Ticket"."Last Modified Date"],

     ["Fact Ticket"."Nb Group Transfers"],

     

FROM

;

Thanks,

Arun

3 Replies
lironbaram
Partner - Master III
Partner - Master III

hi

does the field company is one of the fields in the table ?

is so try

If(len(Country123)<2,Company,Country123) as Country123,

Not applicable
Author

Hi Lirom,

Thanks for the reply. After using the above statement in my load script, now I am able to see the values in Country123 column. But the Region is still showing blank.Please advise.

Thanks,

Arun

lironbaram
Partner - Master III
Partner - Master III

hi

did you map also the company field to regions

otherwise you want be able to add region for those records