I'd like your help to figure out something. This is my DB :
I want to count, for jour_10 to jour_18, how many column is not empty, for each row. For exemple, the first line, you'll have var=5, the second one var=5, the third var=4, etc...
How can I do it ?
hope I understand your question
Did you try with ?
Please see the attachment.
We have done this in qlikview. Use the jour10 to 18 as expressions and then use the if clause.
This was this kind of idea, except I had a problem with my fonction, so I used IsNull() for each day and (* -1) to make it positive
Retrieving data ...