Count number of columns not empty

[#1]

Hi !

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 ?

[maxgro · Accepted solution]

Hi

hope I understand your question

Did you try with ?

NumericCount(jour_10)+NumericCount(jour_11)+NumericCount(jour_12)+...........

[#3]

Hello,

Please see the attachment.

We have done this in qlikview. Use the jour10 to 18 as expressions and then use the if clause.

THanks,

Angad

[#4]

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