topic Re: Create new field from parse in QlikView

Create new field from parse

cbaqir — Wed, 06 Nov 2019 02:57:44 GMT

I currently have several fields that have values such as: "CCL: 0.50; ClinDoc: 9.00; Core: 0.25; CPOE: 1.50;"

My script parses out the different solutions and their number so that they can be added up by Solution. I need to be able to create a new dimension that shows which Solutions are applicable to a specific ticket. In this example, I am hoping for a new field called BUILD_SOLUTION that would include CCL, ClinDoc, Core and CPOE as values. Another ticket might have Core, CPOE and Lab.

I am trying to produce a Mekko chart with Year as a dimension and group by this BUILD_SOLUTION based on the number of hours in each.

Re: Create new field from parse

chrismarlow — Wed, 06 Nov 2019 15:09:59 GMT

Hi,

You can start using SubField to split, so toy application;

data: LOAD * INLINE [ TICKET, THING A, CCL: 0.50; ClinDoc: 9.00; Core: 0.25; CPOE: 1.50; B, CCL: 1.00; ClinDoc: 7.00; CPOE: 2; ]; new_data: LOAD TICKET, SubField(THING, ';') AS THING2 Resident data; drop table data;

Returns;

Will then take a bit more work to split THING2 further.

Cheers,

Chris.

Re: Create new field from parse

cbaqir — Wed, 06 Nov 2019 15:11:38 GMT

I ended up getting what I needed from ValueList.

Re: Create new field from parse

cbaqir — Wed, 06 Nov 2019 15:12:48 GMT

Thanks but I already have that. I needed to create a synthetic dimension but I figure it out.