topic Re: how to deconstruct a field with multiple values in QlikView

how to deconstruct a field with multiple values

Tue, 21 Jul 2015 19:59:16 GMT

Hello, i am just starting with qlikview. I think the solution is excellent. I have a question that has to to with preparing data:

In a customers database there is a field called serviceday indicating on which day a customer is helped e.g.:

0 1 2 3 4 5 6

this means that the customer uses the service on all days of the week.

Another example:

1 3 5

this means that the customer uses the service on monday, wednesday, friday.

question:

1. how do i count the days for each field so that qlikview understand there are 7 days in the first example, and 3 days in the second example?

2. where could i find more info / manuals about these kind of data conversion in qlikview? because i'm expecting a lot in the coming project.

thanks for your response,

hope to find a solution,

Manolito

Qrishna — Tue, 21 Jul 2015 20:40:30 GMT

could you pleasse provide some sample data so that we can play around with ?

maxgro — Tue, 21 Jul 2015 20:47:58 GMT

lenght of the string after removing speces

=len(replace('0 1 2 3 4 5 6 ', ' ', ''))

ramoncova06 — Tue, 21 Jul 2015 20:56:41 GMT

here is another option

=substringcount(Field,' ')

Tue, 21 Jul 2015 21:01:18 GMT

Hi, Sure, here is a query of 10 rows.

Qrishna — Tue, 21 Jul 2015 21:32:23 GMT

See attached document.

output:

Tue, 21 Jul 2015 21:35:05 GMT

Excellent work, much appreciated. I Starred you, thanks for the favor.