Home Business Analytics The Qlik Sense FROM FIELD Perform

The Qlik Sense FROM FIELD Perform

The Qlik Sense FROM FIELD Perform


There are numerous features and strategies inside Qlik Sense that one may overlook to recall when a problem is introduced. These features can all the time use sensible examples of implementation and use case eventualities. Let’s take a look at the FROM_FIELD perform in Qlik Sense.


Load * FROM_FIELD is a helpful script perform in Qlik Sense that permits you to parse the contents of a single column into many columns or rows. Listed here are some sensible examples:

  • Tackle: Shopper Addresses are captured inside a single column on the supply system.
  • Monetary: Chart of Accounts – Permits the jagged hierarchy of the chart of accounts to be learn from a single area and transposed to rows or columns.
  • Gross sales: Invoice of Materials – Strains on an Bill inside the Stock Administration Techniques a Invoice of Materials can have a jagged hierarchy saved inside a single column inside the supply system.  It will then want separated into columns for reporting functions.
  • Web site: Knowledge captured inside a single column and desires introduced in a number of columns.


This script instance gives the Tackle parsed out into columns:

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 (Tackle, CustomerData)
(txt, utf8, no labels, delimiter is '|', msq);

Pattern Output:

Output of Qlik Sense From Field Parse Columns


This instance script gives the Net Knowledge parsed out into rows.

Web sites:
Load * Inline [
Website_ID, URLs
2546478SW$@265, www.cnn.com|www.foxnews.com|www.usatoday.com|www.nytimes.com
152478ER%^&154, www.google.com|www.snapchat.com|www.facebook.com|www.twitter.com

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

Pattern Output:

Output Qlik Sense From Field Parse Rows

Alternatively, this may then be used as a filter inside the utility, not only for output in a chart or graph.


Qlik Sense affords flexibility and creativity to beat the challenges of knowledge and the way greatest to current it.  This instance of the FROM_FIELD perform will hopefully assist spark a inventive answer to your subsequent problem.

Preserve Studying: Cumulative Sum Expression Writing In Qlik Sense



Please enter your comment!
Please enter your name here