Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

During script load I would like to include a made up field from other fields

Hello, I'm fairly new to QlikView and would include a made up field from other fields.

script data load with 23 fields and include this new field  [Won Reasons combined]

Won_Data:

LOAD [Opportunity Id],

[Won Reasons combined] = [Won  Reasons] & ", " & [Won Reason 2] & ", " & [Won Reason 3]

     WHERE  ((([Won  Reasons]) Is Not Null Or ([Won  Reasons])=""))

          OR ((([Won Reason 2]) Is Not Null Or (.[Won Reason 2])=""))

          OR ((([Won Reason 3]) Is Not Null Or ([Won Reason 3])=""));

[State],

[zip],

[Solution],

[Won Reasons],

[Won Reason 2],

[Won Reason 3]

FROM

(qvd)

WHERE WildMatch([Segment Detail], 'SMB Focus') And WildMatch([Fiscal Period], '0','1');

Your help is greatly appreciated...

2 Replies
swuehl
MVP
MVP

You can create new fields like

Won_Data:

LOAD [Opportunity Id],

       [Won  Reasons] & ',' & [Won Reason 2] & ',' & [Won Reason 3] as [Won Reasons combined],

       ...

text literals would be enclosed in single chars, concatenation operator is &

You can use a conditional function to check for conditions:

Won_Data:

LOAD [Opportunity Id],

       If(not isnull( [Won  Reasons]) or not isnull( [Won  Reasons 2]) or not isnull( [Won  Reasons 3] ),

          [Won  Reasons] & ',' & [Won Reason 2] & ',' & [Won Reason 3]

     )  as [Won Reasons combined],

       ...

Not applicable
Author

Thanks much...   Greatly appreciated