The Qlik Sense FROM FIELD Serve as


There are lots of purposes and methods inside of Qlik Sense that one may omit to recall when a problem is gifted. Those purposes can all the time use sensible examples of implementation and use case situations. Let’s have a look at the FROM_FIELD serve as in Qlik Sense.


Load * FROM_FIELD is an invaluable script serve as in Qlik Sense that lets you parse the contents of a unmarried column into many columns or rows. Listed below are some sensible examples:

  • Cope with: Shopper Addresses are captured inside of a unmarried column at the supply gadget.
  • Monetary: Chart of Accounts – Lets in the jagged hierarchy of the chart of accounts to be learn from a unmarried box and transposed to rows or columns.
  • Gross sales: Invoice of Subject matter – Strains on an Bill inside the Stock Control Methods a Invoice of Subject matter may have a jagged hierarchy saved inside of a unmarried column inside the supply gadget.  This will likely then want separated into columns for reporting functions.
  • Web site: Information captured inside of a unmarried column and desires offered in more than one columns.


This script instance supplies the Cope with parsed out into columns:

Cope with:
Load * Inline [
Customer_ID, CustomerData
1101, 1101|Catering Service|25648 Fisherman Drive|Bellevue|NE|68005|United States
1102, 1102|Wedding Venue|PO Box 354 RW|Portsmouth|NH|03801|United States

Load *
FROM_FIELD (Cope with, CustomerData)
(txt, utf8, no labels, delimiter is '|', msq);

Pattern Output:

Output of Qlik Sense From Field Parse Columns


This case script supplies the Internet Information parsed out into rows.

Internet sites:
Load * Inline [
Website_ID, URLs

Load *
FROM_FIELD (Internet sites, URLs)
(txt, utf8, no labels, delimiter is '|', filters(Transpose()));

Pattern Output:

Output Qlik Sense From Field Parse Rows

Then again, this may then be used as a clear out inside the utility, now not only for output in a chart or graph.


Qlik Sense provides flexibility and creativity to triumph over the demanding situations of information and the way perfect to provide it.  This case of the FROM_FIELD serve as will optimistically lend a hand spark an inventive resolution in your subsequent problem.

Stay Studying: Cumulative Sum Expression Writing In Qlik Sense


Supply hyperlink


Leave a Reply

Your email address will not be published. Required fields are marked *