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

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.

Columns

This script instance gives the Tackle parsed out into columns:

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

Pattern Output:

Output of Qlik Sense From Field Parse Columns

Rows

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

Rows:
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.

Conclusion

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



RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments