Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Count number of columns not empty

Hi !

I'd like your help to figure out something. This is my DB : tab.png

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 ?

1 Solution

Accepted Solutions
MVP
MVP

Re: Count number of columns not empty

Hi

hope I understand your question

Did you try with ?

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

3 Replies
MVP
MVP

Re: Count number of columns not empty

Hi

hope I understand your question

Did you try with ?

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

Not applicable

Re: Count number of columns not empty

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

Not applicable

Re: Count number of columns not empty

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

Community Browser