The Qlik Sense FROM FIELD Perform


There are a lot of features and strategies inside Qlik Sense that one would possibly overlook to recall when a problem is offered. These features can at all times 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 means that you can parse the contents of a single column into many columns or rows. Listed below are some sensible examples:

  • Tackle: Consumer 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 subject 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.  This can then want separated into columns for reporting functions.
  • Web site: Knowledge captured inside a single column and wishes offered in a number of columns.


This script instance offers 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 offers the Internet 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 could then be used as a filter throughout 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 finest to current it.  This instance of the FROM_FIELD operate will hopefully assist spark a inventive resolution to your subsequent problem.

Hold Studying: Cumulative Sum Expression Writing In Qlik Sense


Please enter your comment!
Please enter your name here

Share post:




More like this

School Financial savings Calculator – Chime

Banking providers supplied by The Bancorp...

Does Your State Have a Deadline Extension This Tax Season?

Extreme storms, tornadoes, floods, and mudslides have ravaged...

How a High quality Audit Can Assist

by Tori Thurmond / September fifteenth, 2023...

5 Entrepreneurial Mindset Rules That Empower Monetary Literacy

Opinions expressed by Entrepreneur...
%d bloggers like this: