Splitting values

Mon, 25 Mar 2013 11:29:07 GMT

Dear Qlikview Developers,

For an event-based data model I have around 500 events that I want to split.

There are a few components where the events excist of, and I want to split them into 2 or more variables.

For example I have:

E1 and I want to split it as "E" and "1"

1 and I want that as 1

FE1 and I want to split it as "FE" and "1"

KPB1 and I want to split it as "KPB" and "1"

E1-3 and I want to split it as "E", "1" and "3"

DP6-4-3 and I want to split it as "DP", "6", "4" and "3"

The overall "business rule" should be all characters is the first variable, and every single number is another variable.

How can I recognise those as variables?

Thanks in advantage,

Duncan

Re: Splitting values

kaushiknsolanki — Mon, 25 Mar 2013 11:50:32 GMT

Hi,

Have a look at the attached example.

Hope this helps.

Regards,

Kaushik Solanki