Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

QlikView App: Split Values from a String and ApplyMap to Results

cancel
Showing results for 
Search instead for 
Did you mean: 
stevedark
Partner Ambassador/MVP
Partner Ambassador/MVP

QlikView App: Split Values from a String and ApplyMap to Results

Last Update:

May 29, 2013 6:59:04 PM

Updated By:

stevedark

Created date:

May 29, 2013 6:59:04 PM

Attachments

This example shows how data for multiple values contained in a single string can be split up and manipulated to make it easier to analyse.

Often the data coming from source tables is not in a structure that makes it conducive for charting or reporting on.  Various techniques can be employed to sort this out in the load script - making the display of objects in your apps as quick as possible.  The load script in this example splits up values in a data string, converts an id to a string with an ApplyMap and puts it into a simpler table with a CrossTable load.

The QlikView was originally written as a response to the following QlikCommunity thread:

http://community.qlik.com/message/151072

Steve Dark

www.quickintelligence.co.uk

Labels (1)
Version history
Last update:
‎2013-05-29 06:59 PM
Updated by: