This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
1 3 5
this means that the customer uses the service on monday, wednesday, friday.
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,
See attached document.
View solution in original post
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
Hi, Sure, here is a query of 10 rows.
Excellent work, much appreciated. I Starred you, thanks for the favor.