The Qlik Sense FROM FIELD Function

There are lots of functions and methods within Qlik Sense that a person may forget to remember when a difficulty exists. These functions can constantly utilize useful examples of application and utilize case circumstances. Let’s take a look at the FROM_FIELD function in Qlik Sense.

Load * FROM_FIELD

Load * FROM_FIELD is a beneficial script function in Qlik Sense that enables you to parse the contents of a single column into lots of columns or rows. Here are some useful examples:

• Address: Customer Addresses are recorded within a single column on the source system.
• Financial: Chart of Accounts– Permits the rugged hierarchy of the chart of accounts to be checked out from a single field and shifted to rows or columns.
• Sales: Expense of Product– Lines on a Billing within the Stock Management Systems a Costs of Product can have a rugged hierarchy saved within a single column within the source system. This will then require separated into columns for reporting functions.
• Site: Data recorded within a single column and requires provided in numerous columns.

Columns

This script example offers the Address parsed out into columns:

 Address:
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
];.

Columns:.
Load *.
FROM_FIELD (Address, CustomerData).
( txt, utf8, no labels, delimiter is'|', msq);

Sample Output:

Rows

This example script offers the Web Information parsed out into rows.

 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
];.

Rows:.
Load *.
FROM_FIELD (Sites, URLs).
( txt, utf8, no labels, delimiter is'|', filters( Transpose()));

Sample Output:

Additionally, this can then be utilized as a filter within the application, not simply for output in a chart or chart.

Conclusion

Qlik Sense uses versatility and imagination to conquer the difficulties of information and how finest to provide it. This example of the FROM_FIELD function will ideally assist stimulate an innovative option to your next difficulty.

Keep Reading: Cumulative Amount Expression Composing In Qlik Sense