Wednesday, November 30, 2022
HomeBusiness AnalyticsThe Qlik Sense FROM FIELD Operate

The Qlik Sense FROM FIELD Operate

There are lots of capabilities and strategies inside Qlik Sense that one would possibly neglect to recall when a problem is introduced. These capabilities can all the time use sensible examples of implementation and use case eventualities. Let’s take a look at the FROM_FIELD operate in Qlik Sense.


Load * FROM_FIELD is a helpful script operate in Qlik Sense that lets you parse the contents of a single column into many columns or rows. Listed below 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 – Traces on an Bill throughout the Stock Administration Programs a Invoice of Materials can have a jagged hierarchy saved inside a single column throughout 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

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 throughout the software, not only for output in a chart or graph.


Qlik Sense provides flexibility and creativity to beat the challenges of information and the way greatest to current it.  This instance of the FROM_FIELD operate will hopefully assist spark a artistic answer to your subsequent problem.

Hold Studying: Cumulative Sum Expression Writing In Qlik Sense



Please enter your comment!
Please enter your name here

Most Popular

Recent Comments