Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
could you pleasse provide some sample data so that we can play around with ?
lenght of the string after removing speces
=len(replace('0 1 2 3 4 5 6 ', ' ', ''))
here is another option
=substringcount(Field,' ')
Hi, Sure, here is a query of 10 rows.
See attached document.
output:
Excellent work, much appreciated. I Starred you, thanks for the favor.